At 11:23 AM 8/06/2003 +0000, you wrote:

>Hello Helen,
>
> I tried with join and i removed the upper from the query.Now it
>takes 2 mins 40 second for fetching 27019 records.
>I haven't created the index on Cust_nam field yet.For creating index
>i have to get the permission from DBA.Is there any way to improve the
>performance without creating the index on cust_nam field?

No. You must have an index on an ORDER BY field.

>If i give order by <field_name>,that field has to be indexed or what??

Exactly.

heLen