For increase speed of select query, there are some factor like... -By us

How can we optimize or increase the speed of a mysql select
query?

Question Posted / nikunj

Answer Posted / nikunj

For increase speed of select query, there are some factor
like...
-By using Limit in query
-By using Index on table
-By using Primary key

Is This Answer Correct ?

17 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What does $_files means?

981

What is the difference between for and foreach loop in php?

1047

What is a definer in mysql?

929

Write logic to print Floyd's triangle in PHP?

985

What is the correct syntax of mail() function in php?

979

Explain how is it possible to cast types in php?

939

What is the purpose of the php empty function?

911

What is escape data in php?

908

How to remove duplicate values from php array?

1065

Tell me what does the initials of php stand for?

931

Which are the best start and end tags to use?

963

Explain about the data types in PHP?

924

Write a statement to show the joining of multiple comparisons in php?

977

What is $_ env in php?

954

how to track user logged out or not? when a user is idle?

875