Navigation:  Advantage Visual Objects and Vulcan.NET RDD > Developing Visual Objects and Vulcan.NET Applications > Using the Advantage AXSQL RDDs >

AXSQLNTX and Index Optimization

Advantage AXSQL RDDs

Previous pageReturn to chapter overviewNext page

The AXSQLNTX RDD is used to query data from NTX type DBF tables. However, because NTX indexes are not auto-open indexes, the Advantage query engine cannot natively utilize them to optimize query execution. In order to utilize NTX indexes in the query engine, the DBF table and the NTX indexes must be added to an Advantage Data Dictionary. Once in the data dictionary, the query engine will use any NTX indexes associated with tables in the query to help optimize the query execution.