Re: How to identiy tables without indexes

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 2 Jun 1999 20:07:00 +0100
Message-ID: <928350619.13662.0.nnrp-06.9e984b29@news.demon.co.uk>

The most efficient method is probably a SET operation.

Select owner, table_name from dba_tables minus
select owner, table_name from dba_indexes ;

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Sybrand Bakker wrote in message
<928342678.11201.0.pluto.d4ee154e_at_news.demon.nl>...
>Hi Soeren,
>
>Select table_name, owner from dba_tables t
>where not exists
>(select 'x' from dba_indexes i
> where i.owner = t.owner
> and i.table_name = t.table_name)
>
Received on Wed Jun 02 1999 - 14:07:00 CDT