asked
Logical Reads
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
Can you please be more specific than "reduce the logical reads"? What problem(s) are you having?
Hi Tom, As i said earlier.. i need some general information to reduce logical reads. For example some 5 crores of records in a table. Table has some 50 columns. i am reading some Top 10000 from that 5 crores records based on "where clause" and manipulating the status as "used" & moving those data to some other log table. I have required indexes for my queries. Here i am hitting more logical reads. From Development side, i've done all changes. But what should i've to do from Admin side?
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?
19 People are following this question.
