svrajput

 Profile Answers by svrajput 

• Apr 29th, 2009

 

It does not depend upon single entity. In order to optimize it you can look into following things. - Make sure table has primary key. - If there is any field which is used more frequently for searching then index it!. - The order of condition does matters. - In select statement where condition should have indexed column. - Fetch required amount of records from db (use limit clause). e.g. if you want total number of records then use count() function rather than select *.