Re: How to speed up this query?

Stephane Zittoun <acom_at_quaternet.fr> wrote:
>> 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.

There is a bug in using indexes on tables through a view (maybe even a couple). For starters try replacing the view with the actual tables it is a view upon and see if that speeds it up. If so, you have hit the bug. Received on Wed Feb 28 1996 - 00:00:00 CET