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 innodb_buffer_pool_size?

980

How many ways we can retrieve the date in result set of mysql using php?

1119

What is cast in mysql?

903

why not null is not allowed at table level

2761

Which datatype is used for email in mysql?

958

Does mysql support nosql?

912

Which storage engine is best in mysql?

952

How do I free up space in mysql?

913

What do we use to remove duplicate records while fetching a data in mysql ?

964

Is mysqli secure?

894

What is difference between function and procedure in mysql?

956

How does select query work?

940

How many TRIGGERS are allowed in MySql table?

1082

Is mysql a nosql database?

1134

How to dump one database for backup.

938