File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Oracle/OAS and the fly likes Creating Indexes on Number Columns Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "Creating Indexes on Number Columns" Watch "Creating Indexes on Number Columns" New topic

Creating Indexes on Number Columns

Deepika Saxena
Ranch Hand

Joined: Jul 05, 2009
Posts: 59
is there any performance overhead creating indexes on a table columns, whose data type is other than number or interger? i mean if we have a table Emp with the following structure and assume that eno, ename both will only accept unique values. in this case , what is the recommended way to create index? is it on eno or ename? i read that indexes on numbers will have better performance over the indexes, which are created on characters. could any body please explain the reason behind this.
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33113

The fastest index is the one that is used the most. Do you have more queries/joins by number or name? I would imagine number making it the best choice of an index.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Creating Indexes on Number Columns
It's not a secret anymore!