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 the primary and unique key in mysql?

981

what is cte? : Mysql dba

940

How many columns is too many mysql?

894

Which mysql function is used to concatenate string?

1470

How to determine the location of the data directory?

951

How to analyze tables with 'mysqlcheck'?

1197

Write a query to create a database and a table?

886

What is the purpose of -> in the mysql terminal?

1107

How is myisam table stored?

959

What is mysql url?

856

How are mysql timestamps seen to a user?

1006

What data type is money?

859

What you can use regular expression for in mysql? Support your answer with an example?

885

What is a tinyint?

935

can you elaborate on blob and text in mysql? : Mysql dba

887