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!

Indexing Temporary tables

9876564Feb 4 2014 — edited Feb 4 2014

Dear Gurus,

Can you please tell me, Indexing a Temporary table will help in improving the performance of a query where the table is being used ?

Say i have a Temp table where i am staging records for some calculations ( there are more than 0.1 million rows in every run ) , since data is getting inserted during the execution , having indexes on the table will give me any performance benefits?

Please suggest.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2014
Added on Feb 4 2014
5 comments
562 views