query taking too long

hemant_k

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

BeefStu

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

BeefStu

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

hemant_k

hi

was using wrong aliases

issue resolved