what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries
Answers were Sorted based on User's Feedback
Answer / harjeet singh
1.Better data types,2.Better index algorithm,3.better query
written techniques which take the advantage of index
| Is This Answer Correct ? | 3 Yes | 1 No |
How to upload a large file through phpmyadmin in mysql?
Do while loop in mysql procedure?
In mysql, what is joins? Explain
How do you flush privileges?
What is the storage engine used for MySQL?
what are the main differences between MyISAM and InnoDB table storage structures ? what are the advantages and disadvantages in usage of these ?
10 Answers E2 Solutions, Tesco,
The table tbl_sites contains the following data: ----------------------------------------------------- Userid sitename country ------------------------------------------------------ 1 sureshbabu indian 2 PHPprogrammer andhra 3 PHP.net usa 4 PHPtalk.com germany 5 MySQL.com usa 6 sureshbabu canada 7 PHPbuddy.com pakistan 8. PHPtalk.com austria 9. PHPfreaks.com sourthafrica 10. PHPsupport.net russia 11. sureshbabu australia 12. sureshbabu nepal 13. PHPtalk.com italy Write a select query that will displayed the duplicated site name and how many times it is duplicated?
What is difference between mysql and mysql workbench?
What are the technical specifications of mysql?
how we can use more then one primary key in Single Table
What is indexing in mysql?
How many ways we can we find the current date using MySQL?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)