Interested to Buy Any Domain ? << Click Here >> for more details...
what are the optimization techniques for
Query optimization
performance issues and
faster execution of queries
- 2 Answers
- 12798 Views
- Infosys, Sierra Atlantica, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
what are the optimization techniques for
Query optimization
performance issues and
faster executi..
what are the optimization techniques for
Query optimization
performance issues and
faster executi..
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 |
More MySQL Interview Questions
What is a table schema?
What is slow query log in mysql?
How do I switch users in mysql?
Write a query to count the number of rows of a table in mysql.
What is row level locking?
Is mariadb better than mysql?
How do I install mysql on windows 10 64 bit?
How do you index just the first four bytes of the column?
How do I start mysql manually?
how to add a new column to an existing table?
What is dbms in mysql?
How do I delete a mysql user?
Categories
-
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)
