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 |
Does truncate require commit?
If the base table structure is changed what will happen to join index????
what eliminate duplicate without using roenum and not
When is a declare statement required?
What is sql catalog?
What cursor type do you use to retrieve multiple recordsets?
17 Answers Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,
Is sql easier than java?
how to remove records from table? no name 1 a 2 b 1 a 2 b 3 c
How do I run a sql trace?
explain access control lists. : Sql dba
Is it possible for a table to have more than one foreign key?
Which one is better sql or oracle?
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)