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 do you rename a table?
How large can a mysql database become?
How can you retrieve a particular number of records from a table?
How do you connect MySQL database with PHP?
How do I install and use mysql?
How many rows we can insert in a mysql table?
What is msql?
How to find out the second largest element from mysql table
Does mysql scale well?
what is constraints? Also explain the different types of constraints?
What is 'mysqlcheck'?
How do you index just the first four bytes of the column?
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)