<p>A table exists that someone else loaded.  I need to query against the table, but the lack of indexes makes the query plan abysmal.  What I would like to do is detect if there is an index for a particular column, so that I can created it if it does not exist, and not create it if it is already there.</p>

<p>Thanks.</p>

<p>Evil</p>

Become familiar with querying the SYS schema:
```
```
Select * from sys.all_ind_columns where table_name=:TabName and table_owner=:TabOwner;
```
```