Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Remote data access » Directory access servers


Queries on directory access proxy tables

To improve performance, avoid selecting the contents column when using queries that result in a table scan. Whenever possible, use the file name to retrieve the contents of a directory access proxy table. Using the file name as a predicate improves performance since the directory access server only reads the specified file. If the file name is unknown, first run a query to retrieve the list of files, and then issue a query for each file in the list to retrieve its contents.

 Example 1
 Example 2
 Example 3
 Example 4

Delimiter consistency