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 |
|
willfindavid
Starting Member
27 Posts |
 Posted - 2008-06-27 : 06:32:00
|
| Hi,I'm running a stored procedure which has lots of tables and i have set the 'statistics io on' to track the logical reads and to reduce the execution time.A table 'WorkMgmtPlanLineItems' shows the below details.'WorkMgmtPlanLineItems'. Scan count 4764, logical reads 612954, I've created nonclustered indexes for important columns,then too it shows high logical read value.How to reduce the logical reads for this table?Willfin |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-06-27 : 06:37:58
|
| Are you sure your indexes are tuned properly? What does the execution plan say regarding this table, is it using the indexes you created? We'll need to see the code to be able to give you any specific advice...- Lumbago |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-28 : 22:28:11
|
| Or check if need new index with db tuning wizard. |
|
|
|
|
|
|
Reducing the Logical Reads for a table in a SP.