Skip to Main Content

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!

query taking too long

hemant_kMay 9 2022

hi
select br,acno,postdate,
sum(amt) over (partition by br,acno order by postdate) samt
from vcr
above query takes too long to parse ..
am I doing any wrong here ?
please help

This post has been answered by BeefStu on May 9 2022
Jump to Answer

Comments

BeefStu
Answer

Why do you think that? How about providing a reproducible sample test CASE with a create table statement, sample data, number of rows in the table, time taken to run the query
If you think it's a parsing problem provide a SESSION trace, explain plan or tkprof output and show us where the parsing issue may exist.

Your question is similar to saying my car is broken and not saying whether the issue is with the engine, brakes... be more specific so people can help

Marked as Answer by hemant_k · May 9 2022
hemant_k

hi
was using wrong aliases
issue resolved

1 - 2

Post Details

Added on May 9 2022
2 comments
97 views