Select from employees where department_id in 102050100. Below is an example. Creating And Maintaining Oracle Text Indexes Select indindex_name ind_colcolumn_name indindex_type induniqueness indtable_owner as schema_name indtable_name as object_name indtable_type as object_type from sysdba_indexes ind inner join sysdba_ind_columns ind_col on indowner ind_colindex_owner and indindex_name ind_colindex_name -- excluding some Oracle. . SELECT index_name column_position column_name FROM user_ind_columns WHERE table_name table_name ORDER BY index_name COLUMN_POSITION. USER_INDEXES describes the indexes owned by the current user. The overhead by oracle should not be considered I want the used bytes not the allocated bytes. So if the substring exists in the string it will return its position. Select index_name from user_indexes where table_name. For example this plan shows a query using the index orders_i to access the orders table...