what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries
Answer Posted / harjeet singh
1.Better data types,2.Better index algorithm,3.better query
written techniques which take the advantage of index
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is meant by mysqli?
What are the column comparisons operators?
Will mysql remain free?
How to create and drop view in mysql?
1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?
How many ways to get the current time?
How can we optimize stored procedure?
How do I remove a user from mysql?
What are federated tables?
How do I update a variable in mysql?
What is session variable in mysql?
How many mysql connections can handle?
What is the purpose of mysql database?
What is a heap table?
Why do we need mysql?