On 1/27/2011 9:30 AM, Shaun Thomas wrote:
> I'm not sure about orders of magnitude on the storage/index side, but my
> tests gave us a 10% boost if just the keys are switched over to INT or
> BIGINT.
Well, it depends on what you're doing. Searching by an integer vs.
searching by a text string will probably not make much of a difference.
However, if you are calculating sums or averages, there will be a huge
difference.
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
www.vmsinfo.com