Re: Table Design - Index Method

From: Oliver Reiniger <oliver.reiniger_at_isb-ag.de>
Date: Fri, 24 Jan 2003 18:44:42 +0100
Message-ID: <e2ur0b.sgg.ln@ftp2.intern.isb-ka.de>

If this is an DWH: Use Bitmap-Index on the columns that are used as search criteria. Note when using searches with no exact matches (where column like '%string%') your lost with any index.

regards
oliver

"S Madhusudhanan" <madhu17_at_vsnl.net> schrieb im Newsbeitrag news:2eead8c7.0301240717.9882ee9_at_posting.google.com...
> Hi All,
>
> -8.1.7.4 on Solaris 8-
>
> A question on indexing strategy...I have a customer table with about
> 25 Million records with another 25000 rows getting added daily,
> through out the day.
>
> This table has fields like Forename, Surname, Address fields, Zipcode,
> Phone number etc - about 14 columns in all. A front-end app would
> accept search criteria based on any combination of the fields and send
> across the query.
>
> All the columns are almost equally good candidates as search criteria.
> What would be the best method of indexing this table so that it allows
> best throughput for any combination of columns?
>
> Thanks and regards
> S Madhusudhanan
Received on Fri Jan 24 2003 - 11:44:42 CST