Table Design - Index Method

From: S Madhusudhanan <madhu17_at_vsnl.net>
Date: 24 Jan 2003 07:17:15 -0800
Message-ID: <2eead8c7.0301240717.9882ee9@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 - 09:17:15 CST