Performance Tuning




Expensive SQL Statements

Expensive SQL statements: These are defined as sql statements that cause database to read many blocks from disk or buffer. a) User point of view: When transactions using these statements are executed, the response time is…