HP 3000 Manuals HP 3000 Manuals
Appendix E SQL Views for Indices [REV BEG] This appendix is new with the G.2 version of this manual. It includes information on executing SQLINSTL and ODBCVIEW, as well as information on these four views that are related to indices: * SYSTEM.IMAGEKEY * CATALOG.IMAGEKEY * SYSTEM.TPINDEX * CATALOG.TPINDEX Information related to these views for B-Tree indices is also included: * SYSTEM.INDEX * CATALOG.INDEX [REV END] Whenever you ATTACH a database to a DBEnvironment, the definitions for TurboIMAGE/XL and third-party indices (TPIs) are entered in the system catalog of the DBEnvironment. The definitions of TPIs are propagated to all DBEnvironments the database is attached to. You can observe the indices in the SQL views.