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

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

Question Posted / jawed

Answer Posted / jawed

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

Is This Answer Correct ?

23 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is the difference between mysql and sql?

1099

What is msql?

1048

Where is mysql used?

1031

What is ibdata1?

961

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

1015

What is “i_am_a_dump” flag in mysql?

1130

What is unique key in mysql?

1045

How do I restore a mysql database?

1134

How to delete an existing column in a table?

1001

What is cursor in mysql?

943

What is the function of myisamchk?

1016

What is csv?

1012

using primary can we relate two table, with out foreign key?

2761

What is procedure in mysql?

980

What is identity in mysql?

1027