Re: Query to see all tables without index.

From: Julio Negueruela <julio.negueruela_at_si.unirioja.es>
Date: Wed, 26 May 1999 14:05:07 +0200
Message-ID: <374BE373.43CF0FD2@si.unirioja.es>

tim_mcconechy_at_my-dejanews.com escribió:
> =

> Hi!
> I am looking for a query...
> =

> To find all tables which don't have an index on a particular column..
> =

> that is all tables in user_tables which have the column called mainkey
> and do not have an index on this column????
> =

> Any ideas???

If I understood well:

Select owner,table_name from dba_tab_columns  where column_name = 'MAINKEY'
minus
select table_owner, table_name from dba_ind_columns  where column_name = 'MAINKEY';

Hope this help.
-- =

Julio Negueruela
DBA Servicio Informático

Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180

mailto:julio.negueruela_at_si.unirioja.es Received on Wed May 26 1999 - 07:05:07 CDT