InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
When Would You Prefer Logical File Than Opnqryf? |
|
Answer» The physical file you are working with very large, CREATING and using a LOGICAL file will allow an application to perform faster than using an open query file. Since access paths created by open query files are temporary, APPLICATIONS that use an access path FREQUENTLY will be more EFFICIENT using a logical file, since the access path will not have to be rebuilt every time the file is open. The physical file you are working with very large, creating and using a logical file will allow an application to perform faster than using an open query file. Since access paths created by open query files are temporary, applications that use an access path frequently will be more efficient using a logical file, since the access path will not have to be rebuilt every time the file is open. |
|