facebook twitter youtube
Replication Query Optimization DB Tuning Server Load and Query Locking Linux Download Interview Questions Basic DB Commands Mysql
Query Optimization
in Query Optimization - 04 Dec, 2013
by Zafar Malik - no comments

a) Proper data filteration (with the help of where clause) b) Use Explain with select statements to verify the Execution plan of query. If MySQL is doing full table scan then create index on columns being used in Where clause. c) Create index on searching fields. d) Use column names instead of * in select […]

in Query Optimization - 27 Aug, 2013
by Zafar Malik - no comments