Re: THE PEPSI CHALLENGE!!! (of dB's)

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 28 Jan 1999 12:37:01 -0000
Message-ID: <917526994.2766.0.nnrp-08.9e984b29@news.demon.co.uk>

Your requirement sounds the ideal problem for bitmapped indexes, however as soon as you change from

surname = 'bloggs'
to

soundex(surname) = soundex('smith') or

post_code like 'AB%'

then it gets much harder to estimate the hardware you need (and you need more of it).

Have a look on my website for the article on bitmap indexes, the numbers quoted there might give you a starting point.

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk Received on Thu Jan 28 1999 - 06:37:01 CST