HI, What are all the steps we need to take from DB Development & DB administration side to reduce the logical reads?? I need some general information. From Dev side, we could add required Indexes. But i want to know about Admin side changes. Generally while creating database, it will get created with its own default values. What are all the changes we need to do for better performance from DB admin side. Please advise Regards Karthik
Have you examined the execution plan? Are the indexes fragmented? Are the statistics up-to-date? NB Logical reads mean: data is already in memory, so no I/O involved. You're not meaning physical reads?