Re: Query to see all tables without index.

From: Marc <E.Mail_at_address.com>
Date: Thu, 27 May 1999 07:37:08 +0200
Message-ID: <7iilqq$8fl$1@vkhdsu24.hda.hydro.com>

You can try this:

select table_name
from user_tab_columns utc
where column_name = 'MAINKEY'
and not exists(
  select 1
  from user_ind_columns
  where table_name = utc.table_name
  and column_name = utc.column_name)
/

tim_mcconechy_at_my-dejanews.com wrote in message <7ign69$jmi$1_at_nnrp1.deja.com>...
>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???
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Thu May 27 1999 - 00:37:08 CDT