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 can you filter the duplicate data while retrieving records from the table?
How can you change the password of a mysql user?
Why do we write stored procedures?
Explain the different types of constraints?
What is mysql in dbms?
Is mysql an oracle product?
How do I show users in mysql?
What is localhost in mysql?
change column name and make a unique column so we get no dupes.
How to create trigger in mysql workbench?
What is pdo mysql?
Is mysql a odbc?
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)