subi_sybase

 Profile Answers by subi_sybase 

• Dec 20th, 2010

 

Do a set showplan on
check each query and see if any table scan is used....
if yes, check if any index is present on tables...
if index is not present try adding it....
if index is present, determine what factor is causing the index to be not used....it might be some SARG used which is not indexed....

Cost of a query is measured based on how many logical and physical read take place....
if more physical read i.e. pages are read from disk, then query will take more time....
logical read is reading from cache....