With SQL queries on the system tables iiindexes and iiindex_columns, you can display all indexes, the indexes of a specific table, as well as their included columns in an Actian Ingres database. Additionally, you can check whether a specific table field is included in an index. The appropriate SELECT and JOIN queries are explained using concrete examples.
