How do I optimize a selected query in mysql?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More MySQL Interview Questions

What are aggregate functions in mysql?

1 Answers  


What is difference between oracle sql and mysql?

0 Answers  


What is a tinyint?

0 Answers  


what is a cursor? : Mysql dba

0 Answers  


How many columns can a table have?

0 Answers  






How to enter Characters as HEX Numbers?

0 Answers  


What are stored procedures and functions?

0 Answers  


How do I restore a mysql database dump file in linux?

0 Answers  


when i declare date data type in sql ,i inserted the date 22-10-2012,but my result is in different date 1894-07-11 any one pls help me what's wrong in my query Create table orders(od_id int,od_name varchar(10),od_date date) insert into orders values(1,'sai',22-10-2012) and any one pls suggest what i can learn for 3 years real time experenice in sql because i am looking for database field

1 Answers  


A select query over a large table runs very slow because of the growing number of entries in that table. What different measures could be taken to improve speed?

5 Answers  


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

0 Answers  


Explain MySQL optimization?

1 Answers  


Categories