Structure of Integrated Indexes

OLE DB Programmer's Reference

The structure of a nonintegrated index rowset is rigidly defined: The key columns of the index occur in order, and there is a separate column—not column 0—that contains the bookmarks that point to the base table rowset.

These restrictions do not apply to rowsets with integrated indexes. Forcing the key columns to occur in order could force the rowset to reorder the rowset columns each time the consumer changes the current index—an unacceptable result. The separate column of bookmarks pointing to base tables is not needed, as was explained in the preceding section, "Using Integrated Indexes."

To determine which columns are key columns and the order in which they occur, the consumer calls IRowsetIndex::GetIndexInfo. The provider returns an array of DBINDEXCOLUMNDESC structures with the DBIDs of the key columns and the key types (ascending or descending) of each column. The arrays are returned in order from most significant to least significant. To determine the ordinals of the key columns, the consumer calls IColumnsInfo::MapColumnIDs with the returned DBIDs.

1998-2001 Microsoft Corporation. All rights reserved.



Microsoft Ole Db 2.0 Programmer's Reference and Data Access SDK
Microsoft OLE DB 2.0 Programmers Reference and Data Access SDK (Microsoft Professional Editions)
ISBN: 0735605904
EAN: 2147483647
Year: 1998
Pages: 1083

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net