what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries
- 2 Answers
- 11702 Views
- Infosys, Sierra Atlantica, I also Faced
- E-Mail Answers
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 |
What is mysql protocol?
What is the query to display top 20 rows?
Is postgresql better than mysql?
How do you create a table in mysql workbench?
Is mysql port 3306 tcp or udp?
What?s the difference between query_cache_type 1 and 2?
In mysql, what is the default storage engine?
What is data types in mysql?
What does mysqli stand for?
Can you tell a way to know the number of days between the two given dates in php?
What is difference between mysql and mariadb?
What is dbms in mysql?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
