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
hi All,
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 somebody please help me in tuning this query?
The 2 tables
