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!

Index required or Not

Chanchal WankhadeOct 13 2012 — edited Oct 14 2012

Dear All,

I have a table which i regulary truncate and insert a fresh records in it.

I also extract data from this table on regular basis.
Now my question is
1) Should i create index on one column which i use in query, so query performance will increase.

2) What if i am truncating all the data from this table and again inserting fresh data into it so index will work in this situation.

Regards,
Chanchal Wankhade.

This post has been answered by Frank Kulash on Oct 13 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 11 2012

Added on Oct 13 2012

10 comments

181 views