If you are using SQL Server , you should probably use Index Tuning Wizard that comes with SQL Server profiler to optimize your indexes.... ------ Ashok Hariharan http://www.unganisha.org ------