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 |
In which language it is written?
Where is the mysql config file?
How to get help information from the server?
List the different types of normalization?
What are numeric data types?
Explain triggers and stored procedures?
What is the difference between mysql and sql?
What is append query?
What is maximum table size in mysql?
How do I copy a table in mysql workbench?
What is difference between mysql and mysqli?
Is mysql open source?
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)