How to find a performance problem and its tuning solution?
0:07:30
Ways of Getting the Execution Plan and the Statistics
0:09:13
Using the Real-Time SQL Monitoring Tool Part 1
0:09:13
Using the Real-Time SQL Monitoring Tool Part 2
0:03:41
Using the Real-Time SQL Monitoring Tool Part 3
0:09:13
CODE: Using the Real-Time SQL Monitoring Tool
0:03:41
Using the Trace Files & TKPROF Utility - Part 1
0:03:41
Using the Trace Files & TKPROF Utility - Part 2
0:07:30
Using the Trace Files & TKPROF Utility - Part 3
0:06:12
CODE: Using the Trace Files & TKPROF Utility
0:09:13
Get What You Need Only
0:06:12
CODE: Get What You Need Only
0:03:41
CODE: Index Usage
0:07:30
Using Concatenation Operator
0:09:13
CODE: Using Concatenation Operator
0:06:54
Using Arithmetic Operators
0:03:41
CODE: Using Arithmetic Operators
0:03:41
Using Like Conditions
0:06:54
CODE: Using Like Conditions
0:06:12
Using Functions on the Indexed Columns
0:06:54
CODE: Using Functions on the Indexed Columns
0:06:54
Handling NULL-Based Performance Problems
0:06:12
CODE: Handling NULL-Based Performance Problems
0:09:13
Using EXISTS instead of IN Clause
0:06:12
Using TRUNCATE instead of DELETE command
0:03:41
CODE: Using TRUNCATE instead of DELETE command
0:03:41
Data Type Mismatch
0:06:54
CODE: Data Type Mismatch
0:07:30
Tuning Ordered Queries
0:03:41
CODE: Tuning Ordered Queries
0:06:12
Retrieving the MIN & MAX Values
0:09:13
CODE: Retrieving the MIN & MAX Values
0:03:41
UNION and UNION ALL Operators (Which one is faster?)
0:03:41
UNION and UNION ALL Operators (Which one is faster?)
0:07:30
Avoid Using the HAVING Clause!
0:09:13
CODE: Avoid Using the HAVING Clause!
0:09:13
CODE: Be Careful on Views!
0:06:54
Create Materialized Views
0:06:12
CODE: Create Materialized Views
0:03:41
Avoid Commit Too Much or Too Less!
0:07:30
Partition Pruning
0:07:30
CODE: Partition Pruning
0:06:54
Using BULK COLLECT
0:06:12
CODE: Using BULK COLLECT
0:07:30
Tuning the Join Order
0:09:13
CODE: Tuning the Join Order
0:06:12
Multitable DML Operations
0:06:54
CODE: Multitable DML Operations
0:07:30
Using Temporary Tables
0:06:12
CODE: Using Temporary Tables
0:06:12
Combining SQL Statements
0:06:12
CODE: Combining SQL Statements
0:03:41
Using "WITH" Clause
0:06:54
CODE: Using WITH Clause
0:07:30
Using Analytical Functions
0:07:30
CODE: Using Analytical Functions
0:09:13
SQL Tuning Techniques
0:03:41