Index Performance

PeopleSoft Index Peformance

Should a PeopleSoft table that has only 1 field in it have that field also defined as a key? Software/Hardware used: PeopleTools 8.17 / Oracle 9i

indexes on a large table

hello, i got a 5milion rows on a single table, my database is sql2005 and my select is : SELECT top * FROM tbl1 WHERE ip_from <= 3515134258 and ip_to >= 3515134258 the 3515134258 is on a sample but the format is similar: SELECT top 1 * FROM tbl1 WHERE ip_from <= [value] and ip_to...

Index Tuning Wizard shows error occurred while executing SQL statement but I can't find the problem

I am facing a strange problem while using the Index Tuning Wizard (ITW) in SQL Server 2000. It shows error occurred while executing a SQL statement. I've checked every thing like trace is okay, as they show no problem with SQL Server 2005. Kindly give me some solution, URGENT.