Answer Posted / 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 |
Post New Answer View All Answers
What is an oracle stored procedure?
Explain spool.
What is cursor in pl sql?
Can we use view in stored procedure?
Which sorts rows in sql?
What is a join?
How do I run pl sql in sql developer?
What is time based sql injection?
What does := mean in pl sql?
What is the difference between delete and truncate statement in sql?
What are sql indexes?
What is pl sql package?
How can you view the errors encountered in a trigger?
what is the difference between cluster and non cluster index? : Sql dba
Can instead of triggers be used to fire once for each statement on a view?
