1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries

Question Posted / pk

Answers were Sorted based on User's Feedback



what are the optimization techniques for Query optimization performance issues and faster executi..

Answer / jawed

User the following
1.litmit
2.keys
3. indexing

Is This Answer Correct ?    23 Yes 6 No

what are the optimization techniques for Query optimization performance issues and faster executi..

Answer / 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

More MySQL Interview Questions

Why is it called mysql?

1 Answers  

What is mysqli_result?

1 Answers  

What are the three types of queries?

1 Answers  

What is the date format in mysql?

1 Answers  

What is the difference between b-tree and hash indexes?

1 Answers  

What is difference b/w composit key n primary key and forigion key?

4 Answers  

How do I completely remove mysql from windows?

1 Answers  

What is msql?

1 Answers  

How to load data files into tables with 'mysqlimport'?

1 Answers  

How to install mysql?

1 Answers  

What do you understand by mysql terminal?

1 Answers  

What is the use of concat() in mysql?

1 Answers  

For more MySQL Interview Questions Click Here
Categories