Skip to Main Content
Forums

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!

performance problem with huge volume of data in a table

srikarMar 16 2011 — edited Mar 17 2011
Hi everybody,

I have a table with size of 8GB in my database.My query has to fetch 1 year records(nearly 1 crore records) it is taking approximately 8-10 minutes.

I used following factors

1. The table is range partitioned on date column.
2. Indexes are created.
3. I used hint parallel .
4. Gathered statistics.

can any one suggest me in this scenario to fetch records in less than 1 minute.

Thanks in advance
srikar.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2011
Added on Mar 16 2011
9 comments
451 views