Re: How to speed up this query?
From: Stephane Zittoun <acom_at_quaternet.fr>
Date: 1996/02/23
Message-ID: <312D93A8.5F9A_at_quaternet.fr>#1/1
Date: 1996/02/23
Message-ID: <312D93A8.5F9A_at_quaternet.fr>#1/1
> select distinct view1.i_mfr_id, view1.i_mfr_des,
> view1.c_code, tablex.c_code
> from view1, tablex
> where view1.c_code = tablex.c_code;
Alex,
you wrote > select distinct view1.i;
it seems that view1 is a view, not a table.
I'm not sure thant in this case, all original tables indexes are used.
Try the same query, but substitute the view name by the view definition;
Hope it helps. Received on Fri Feb 23 1996 - 00:00:00 CET