Index on INT Columns
Posted by: Chris Nagle
Date: March 21, 2008 09:29AM

Hi,

Sorry if this topic has been dealt with before. I tried searching for it and came up with nothing useful. My question is there a point to putting index on int columns? I have a primary key on the table already which is a auto incrementing column and I do a lot of left joins on the table. And as the data set grows larger I want to speed up queries. All the columns I do left joins are int. So is there a point to adding them as indexes? Or do you only really gain speed when you use multiple column indexes?

Thanks in advance,
Chris

Options: ReplyQuote


Subject
Written By
Posted
Index on INT Columns
March 21, 2008 09:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.