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


Please Help Members By Posting Answers For Below Questions

What is meant by mysqli?

500


What are the column comparisons operators?

624


Will mysql remain free?

508


How to create and drop view in mysql?

509


1)for snapshot replication which agents used? 2)for Transcation replication which agents used? 3)for merge replciation which agents used?

1555






How many ways to get the current time?

510


How can we optimize stored procedure?

493


How do I remove a user from mysql?

562


What are federated tables?

607


How do I update a variable in mysql?

497


What is session variable in mysql?

503


How many mysql connections can handle?

490


What is the purpose of mysql database?

485


What is a heap table?

484


Why do we need mysql?

529