what is sql optimization
Answer / anupam bhatt
SQL optimization or tuning is the process to improve upon your sql queries to make them more efficient and avoid common pitfalls like multiple database round trips etc. Basically do more work with fewer queries to make the application fast and manageable.
This can be achieved by various ways like joining multiple queries in to one to avoid multiple network round trips, add indexes to the tables which are frequently accessed to reduce the turnaround time, fetch only the required data instead of a generic query getting all of the data of the table etc.
| Is This Answer Correct ? | 2 Yes | 2 No |
Why self join is used in sql?
write a query to find 4th max salary
Can we have two clustered index on a table?
How to run pl sql program in mysql?
What is the difference between execution of triggers and stored procedures?
how can create data base link for tow servers (scott schema) give examples plz
What is a bitmap index?
4 Answers Choice Solutions, Infosys,
when is the use of update_statistics command? : Sql dba
How to find 3rd highest salary of an employee from the employee table in sql?
what is cursor procedure
What is sql deadlock?
What is difference between joins and union?
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)