ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip   SiteMap shows list of All Categories in this site.
Google
 
Categories  >>  Software  >>  Databases  >>  MySQL
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
How can you do the fine tunning?
 Question Submitted By :: Prasadhari_m@yahoo.com
I also faced this Question!!     Rank Answer Posted By  
 
  Re: How can you do the fine tunning?
Answer
# 1
Fine tuning is mostly done for the SELECT statements.
Use the Keyword EXPLAIN in front Of your SELECT Statement.

eg: EXPLAIN SELECT t1.id, t2.id FROM table1 AS t1 INNER JOIN
TABLE2 AS t2 ON .....;
The result will be like this
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
| id | select_type | table     | type | possible_keys   |
key             | key_len | ref   | rows | Extra       |
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
|  1 | SIMPLE      | table1    | ref  |        t1       |  
     t1       |      4  | const |    2 | Using where |
+----+-------------+-----------+------+-----------------+-----------------+---------+-------+------+-------------+
1 row in set (0.00 sec)

if the "ref" column value is found to be ALL, then the two
tables must be joined properly. if the "Extra"  gives values
like 
Using temporary; Using filesort then the columns  in the
JOIN conditions and WHERE clause must be indexed properly. 
By doing this we can make our queries executing faster.
 
Is This Answer Correct ?    0 Yes 0 No
Subeeshbabu V
 
  Re: How can you do the fine tunning?
Answer
# 2
If ur Television was not working means we have to do the
fine tuning.
Step 1:Take the Remote
Step2:Go the menu Control OR Program 
Step3: In Menu Control Or program u will see fine Tunning
Step4:Change the status of the arrow in fine tunning
Step5:if the Television still not working means
Step6: Take ur Television and go to beach. Jump into the sea
along with ur Television
 
Is This Answer Correct ?    0 Yes 1 No
Shankri
 
 
 

 
 
 
Other MySQL Interview Questions
 
  Question Asked @ Answers
 
What are the different table present in MYsql?  1
Explain MySQL optimization?  1
what is the difference between MyISAM and INNO DB in MySQL with the Advantage and disadvantage ABC2
What happens if a table has one column defined as TIMESTAMP?  1
how we can use more then one primary key in Single Table Systematix7
What?s the default port for MySQL Server? Yahoo2
i made a table in sql server 2000 and in a column i want to add image path of a picture present in my hardisk... so using insert statement how will i insert the path of the image in the table?? WebTech1
What happens when the column is set to AUTO INCREMENT and you reach the maximum value for that table?  1
How can we know the number of days between two given dates using MySQL? Webworks2
How can you do the fine tunning? ACC2
How do you index just the first four bytes of the column?  2
ru compare the 2 null values? ACC1
How many services is running in sql server? ACC3
How can increase the performance of MySQL select query? Span-Systems1
What are HEAP tables in MySQL?  1
What are MySQL transactions?  1
What?s the difference between PRIMARY KEY and UNIQUE in MyISAM?  2
about join  2
How do you control the max size of a HEAP table?  1
Explain advantages of MyISAM over InnoDB?  1
 
For more MySQL Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com