Re: Is is possible to tune this SQL statement?

Jimmy,
1. view do not impact performance. it is the underline sql determines how well a query performs.
2. the number of rows in joining operation has much greater impact on performance than the number of joining tables. Ted Chyn
In article <37DBE7F8.7432AF95_at_comp.polyu.edu.hk>,   Jimmy <c6635500_at_comp.polyu.edu.hk> wrote:
> Hello all,
>
> I create a view AAA joining 5 tables and the resulting rows is
over
> 50000. I am doing query on AAA with the following SQL statements:
>
> select distinct(field) from AAA where condition...
>
> (View AAA has 50 columns, only the column with varchar2 data type
is
> retrieved)
> The condition part is different each time. Is there any way to
> improve the above query time? If the fields to retrieve is only on two
> or three columns (each time one field is retrieved but the condition
> part is again different each time), can I built index on these columns
> (i.e. can I built index on view column)? Or is there other ways can
> improve the query time?
>
> Thanks,
> Jimmy
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Sep 13 1999 - 19:37:51 CEST