I"m a little confused by the query you posted.. it looks like it would
work, although with many redundant subqueries to get there. From your
requirement, I don't understand why you needs to wrap it in a self-
referencing subquery..
Why does this not give you the same logical value?
selec
Unfortunately, I cannot create indexes for these tables. These are on
production and I cannot modify the tables in anyway.
Also, none of the columns are unique in nature - they just serve as a
reporting store.
Is there anyway that I can tune the select query itself and hope some
performance enhanc
On Wed, 2005-10-19 at 17:39 -0400, Anoop kumar V wrote:
> I have 2 tables used for reporting and there are no primary keys or
> indexes for either. I am trying to run a select query to identify some
> rows that need to be removed. But for around 100,000 rows the query is
> taking too long. Can some
