Skip to Main Content

SQL & PL/SQL

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!

Aggregate function MAX() function taking too much time.

d3dc6df9-7ba3-4b13-9a6a-f8a96376d96cMar 12 2015 — edited Mar 13 2015

Hi Dear All,

I am just executing simple below statement but its taking too much time around 15 to 20 minutes. could anyone help me i have created indexed portioned etc everything on this table. it contains around 560000000 record.

select max(PrimaryID)  from  asalog;

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 10 2015
Added on Mar 12 2015
11 comments
2,394 views