SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

query with trim function running more than 15 hours..

886413Dec 9 2011 — edited Dec 9 2011

Hi,

I have one select query which is running more than 15 hours.I have many trim() functions in that.and i have index for some columns for the tables that i used in that query.but it is not considering those indexes..

select
DISTINCT

trim(A.x) x,

trim(B.y) y,....... from A,B

Can anyone tell why this query is taking more time?and is there any other way for using the trim function?

Thanks in advance..

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 6 2012

Added on Dec 9 2011

#sql-developer

1 comment

367 views