Skip to Main Content

Oracle Database Discussions

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!

Composite index or single column index

11g.DBAJun 20 2013 — edited Jun 20 2013

Hi,

We want to index some columns in our database.

Some of those columns are already indexed.

We are thinking to drop these single column indexes and want to create composite index for these columns i.e. creating single index with several columns rather than several indexes each with one column.

Is this approach fine??

Thanx in advance

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2013
Added on Jun 20 2013
8 comments
6,688 views