Re: Is is possible to tune this SQL statement?

You can't build an index on a view.
Try to change your query without using the "DISTINCT" clause.

Jimmy 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
Received on Mon Sep 13 1999 - 02:24:02 CDT