List three advantages of using the FORCE_DISK option in Tibco Data Virtualization (TDV)?
Article ID: KB0079900
Updated On:
| Products | Versions |
|---|---|
| TIBCO Data Virtualization | - |
Description
FORCE_DISK option can be supplied as a query hint. It has the below advantages:
Issue/Introduction
This document lists three advantages of using the FORCE_DISK option in Tibco Data Virtualization (TDV).
Resolution
p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; color: #454545}
1. It frees up memory for other requests and server operations.
2. It is useful for known queries which consume large amounts of memory, or always spill from memory to disk.
3. It helps in moving query from memory to disk may be more expensive than running entire query on disk with FORCE_DISK.
Feedback
Yes
No
Powered by
