varchar index vs. integer index
Posted by:
Alex P
Date: March 09, 2009 03:27AM
Hello,
I have in a table an index on a varchar column. This column may contain about 300 distinct values, each value having tens of thousands, hundreds of thousands or even million of corresponding rows (this is why the index on it was necessary in the first place).
I have the possibility to transform the column in integer. Does this help my index in any way? What would be the gain in performance when i execute queries which have that column in the where clause?
Edited 1 time(s). Last edit at 03/09/2009 03:29AM by Alex P.
Subject
Views
Written By
Posted
varchar index vs. integer index
13496
March 09, 2009 03:27AM
6358
March 10, 2009 08:28PM
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.