All_ind_columns

Identify Indexed Columns in Oracle Database Tables Purpose Which columns does this index cover, and in what order? A developer asks it before adding an index that might already exist. A DBA asks it when a query scans a whole table and the team swears an index is in place. The answer is in the data dictionary, one row …