Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
reachvenu
Starting Member
1 Post |
 Posted - 2006-02-13 : 15:30:29
|
| I have a stored procedure which selects the rows from a table (about 20 million rows)based on the parameters (7 parameters like firstname, lastname) passed. I have indexes on all the 7 fields of the table. But the time taken to retrieve the records is more than a minute. I want to bring it to less than 5 seconds. Please help me out.Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-13 : 16:04:24
|
quote:
I have indexes on all the 7 fields of the table
This is almost certainly not a good idea. Inserts, updates, and deletes will be negatively impacted.Please post the query. Also post your indexes and the table.Tara Kizeraka tduggan |
 |
|
|
|
|
|
Performance Tuning