How Can We Optimize Or Increase The Speed Of A Mysql Select Query? – InterviewSolution

InterviewSolution

1.

How Can We Optimize Or Increase The Speed Of A Mysql Select Query?

Answer»

first of all instead of USING SELECT * from table1, use select column1, column2, column3.. from table1
Look for the opportunity to introduce INDEX in the table you are querying.
use LIMIT keyword if you are LOOKING for any specific number of rows from the result set.

Discussion

No Comment Found

Related InterviewSolutions

How To Turn On The Session Support?
What Is The Difference Between Reply-to And Return-path In The Headers Of A Mail Function?
Please Give A Regular Expression (preferably Perl/preg Style), Which Can Be Used To Identify The Url From Within A Html Link Tag.
When You Want To Show Some Part Of A Text Displayed On An Html Page In Red Font Color? What Different Possibilities Are There To Do This? What Are The Advantages /disadvantages Of These Methods?
Tools Used For Drawing Er Diagrams.
How To Reset/destroy A Cookie?
How Can I Retrieve Values From One Database Server And Store Them In Other Database Server Using Php?
If We Login More Than One Browser Windows At The Same Time With Same User And After That We Close One Window, Then Is The Session Is Exist To Other Windows Or Not? And If Yes Then Why? If No Then Why?
What Are The Other Commands To Know The Structure Of A Table Using Mysql Commands Except Explain Command?
What Is The Maximum Length Of A Table Name, A Database Name, Or A Field Name In Mysql?