Interested to Buy Any Domain ? << Click Here >> for more details...
what is sql optimization
- 1 Answers
- 9472 Views
- Fidelity, I also Faced
- E-Mail Answers
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 |
Can we create table in function?
Why functions are used in sql?
What is query optimization in sql?
how to create a test table in your mysql server? : Sql dba
What is RAC in oracle?
what is union? : Sql dba
What is percent sign in sql?
Why coalesce is used in sql?
Explain the difference between triggers and constraints?
What are different types of keys?
What is the difference between sql/pl-sql/embeded sql?
What is a call statement? Explain with an example.
-
Oracle (3253) - 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)
