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
12813 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

What is back end and front end?

911

what is constraints?

1167

What are the benefits of mysql?

937

How to determine the location of the data directory?

967

How can you count the total number of records of any table?

925

How do I grant privileges to a user in mysql phpmyadmin?

959

Is null in mysql?

876

How many rows mysql can handle?

944

How do I edit a trigger in mysql?

898

How to create and drop view in mysql?

916

How to create table show example

981

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

1025

How can I create database in mysql?

933

Does mysql use sql?

899

How to enter numeric values as hex numbers?

980