Forum Stats

  • 3,827,386 Users
  • 2,260,768 Discussions
  • 7,897,223 Comments

Discussions

query taking too long

hemant_k
hemant_k Member Posts: 415 Bronze Badge

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

Tagged:

Best Answer

  • BeefStu
    BeefStu Member Posts: 327 Blue Ribbon
    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

Answers

  • BeefStu
    BeefStu Member Posts: 327 Blue Ribbon
    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

  • hemant_k
    hemant_k Member Posts: 415 Bronze Badge

    hi

    was using wrong aliases

    issue resolved