Skip to Main Content
Forums

Oracle Database Discussions

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!

Benchmarks on select statements

lesakSep 5 2008 — edited Sep 7 2008
Hi,

I'm during preparing test on select statement to check what clause cause the most slow down. Therefore I prepare 3 select statement:
1) select which transform all columns in source table for oracle's functions like: substr, rpad, decode, nvl,upper, mod, greatest, length, power, instr etc..
2) select with big where clause (about 7 lines) which take from 2 tables
3) select which have where, group by, having and order by clauses
Perhaps I will have first result today. But I am very interested what is your experience in this subject?? Which case cause the biggest slow down?

Best.
This post has been answered by 108476 on Sep 5 2008
Jump to Answer

Comments

Manu.
Answer

Dear,

What do you mean by as required? Please post the sample screenshot of the outputs in Toad and in LOV.

Manu.

Marked as Answer by user5345 · Sep 27 2020
user5345

Sir got it. thanks

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 3 2008
Added on Sep 5 2008
#general-database-discussions, #oracle, #performance, #sql
6 comments
406 views