Requesting Integrated Indexes

Whether an index on a base table is integrated or not is reported in the INTEGRATED column of the INDEXES schema rowset. (See Appendix B: Schema Rowsets.)

You can obtain integrated index behavior by opening a rowset on an integrated index ? that is, passing valid table and index IDs to IOpenRowset::OpenRowset. In this case, the consumer deals with a single rowset to read the data in index order, to have access to all base table columns, and to update both the base table and associated index based on calls to IRowsetChange on the rowset.