Indexes
Home Up OleRead MkTbls OleUpdate OSchema OLAP OleDB25 Scroll MkTblsEx FastLoad FilterSort DataShape FastAccess Indexes MultiRecords MultiProcs BLOBs

 

Example Indexes:

        We put indexes on a table, and a database search engine uses them to speed up finding records at the server side. Typically, we can't control indexes to search records at a client side directly. However, OLEDB enables us to do this kind of work using indexes from our codes. The use of indexes at client side is one of best ways to increase data accessing with OLEDB. This example is presented for demonstration of the following how-tos with indexes:

  1. How to open a rowset exposing IRowsetIndex interface.

  2. How to set a range of records according to given index values.

  3. How to seek a fetch position on a given index.

        For other ways to improve performance, see examples FastAccess, FilterSort and Scroll

        Finally, it is notified that you can only experiment this example after you run examples MkTbls and BLOBs.

Goto the list of examples