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

2 Answers
12653 Views
Infosys, Sierra Atlantica, I also Faced
E-Mail Answers

Answer Posted / jawed

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

Is This Answer Correct ?

23 Yes

6 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do I create a schema in mysql?

823

Is mysql and sql are same?

987

What is MySQL?

937

How many TRIGGERS are allowed in MySql table?

1021

Is mysql a framework?

870

What is mysql routine?

854

How to run a sql statement?

966

What is ndb in mysql?

908

What is the difference between primary key and candidate key?

942

What is a text delimiter?

873

Can you tell which of the following where clauses is faster?

843

What is blob in mysql?

955

I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

3886

How do stored procedures work?

954

what is cte? : Mysql dba

892