| Udemy - SQL Tuning/10 HINTS to the database/053 Why HINTS.mp4 |
18 MB |
| Udemy - SQL Tuning/10 HINTS to the database/054 Forcing a specific Join Method.mp4 |
15.9 MB |
| Udemy - SQL Tuning/10 HINTS to the database/055 HINTS list.pdf |
209 KB |
| Udemy - SQL Tuning/11 House Keeping/056 Invalid Optimizer Statistics.mp4 |
20.8 MB |
| Udemy - SQL Tuning/11 House Keeping/057 Checking SQL statements which are performing BAD.mp4 |
21.9 MB |
| Udemy - SQL Tuning/09 Join Methods/052 Sort Merge Join.mp4 |
13.7 MB |
| Udemy - SQL Tuning/09 Join Methods/051 Hash Join.mp4 |
10.2 MB |
| Udemy - SQL Tuning/09 Join Methods/049 Join Methods.mp4 |
3.4 MB |
| Udemy - SQL Tuning/09 Join Methods/050 Nested Loop Join.mp4 |
19.1 MB |
| Udemy - SQL Tuning/12 Design Considerations/059 Separate Tablespace for Data and Index.mp4 |
11.2 MB |
| Udemy - SQL Tuning/12 Design Considerations/060 Index Organized Tables.mp4 |
14.4 MB |
| Udemy - SQL Tuning/12 Design Considerations/058 Effective Schema Design.mp4 |
15.4 MB |
| Udemy - SQL Tuning/12 Design Considerations/061 Partitioned Tables.mp4 |
16.4 MB |
| Udemy - SQL Tuning/12 Design Considerations/062 Bitmap Indexes.mp4 |
17.9 MB |
| Udemy - SQL Tuning/03 Accessing Tables/010 What is my Address.mp4 |
5 MB |
| Udemy - SQL Tuning/03 Accessing Tables/016 Choosing between FULL and INDEX scan.mp4 |
4.5 MB |
| Udemy - SQL Tuning/03 Accessing Tables/013 Table Access by ROWID.mp4 |
8.8 MB |
| Udemy - SQL Tuning/03 Accessing Tables/015 Index Range Scan.mp4 |
10.7 MB |
| Udemy - SQL Tuning/03 Accessing Tables/011 Types of Table Accesses.mp4 |
5.8 MB |
| Udemy - SQL Tuning/03 Accessing Tables/014 Index Unique Scan.mp4 |
10.1 MB |
| Udemy - SQL Tuning/03 Accessing Tables/012 Table Access FULL.mp4 |
7.7 MB |
| Udemy - SQL Tuning/03 Accessing Tables/quizzes/003 Access Paths.html |
4 KB |
| Udemy - SQL Tuning/04 Explain Plan/017 Execution Plan.mp4 |
3.4 MB |
| Udemy - SQL Tuning/04 Explain Plan/023 Execution Plan Example 1.mp4 |
8 MB |
| Udemy - SQL Tuning/04 Explain Plan/018 What should you look for.mp4 |
11.6 MB |
| Udemy - SQL Tuning/04 Explain Plan/021 Traversing through the Tree.mp4 |
9.9 MB |
| Udemy - SQL Tuning/04 Explain Plan/026 Execution Plan Example 4.mp4 |
24.7 MB |
| Udemy - SQL Tuning/04 Explain Plan/024 Execution Plan Example 2.mp4 |
9.7 MB |
| Udemy - SQL Tuning/04 Explain Plan/022 Reading Execution Plan.mp4 |
9.7 MB |
| Udemy - SQL Tuning/04 Explain Plan/020 Rules of Execution Plan Tree.mp4 |
8.7 MB |
| Udemy - SQL Tuning/04 Explain Plan/019 What is COST.mp4 |
4.8 MB |
| Udemy - SQL Tuning/04 Explain Plan/025 Execution Plan Example 3.mp4 |
15.6 MB |
| Udemy - SQL Tuning/06 Index Suppression/033 Use of Arithmetic operators.mp4 |
7.9 MB |
| Udemy - SQL Tuning/06 Index Suppression/030 Index Suppression reasons.mp4 |
4.6 MB |
| Udemy - SQL Tuning/06 Index Suppression/031 Use of operator.mp4 |
15.1 MB |
| Udemy - SQL Tuning/06 Index Suppression/035 Use of operator.mp4 |
6.9 MB |
| Udemy - SQL Tuning/06 Index Suppression/036 Comparing a character column to a numeric value.mp4 |
7.8 MB |
| Udemy - SQL Tuning/06 Index Suppression/037 Use of IS NULL and IS NOT NULL.mp4 |
10.4 MB |
| Udemy - SQL Tuning/06 Index Suppression/032 Use of SUBSTR function.mp4 |
9.5 MB |
| Udemy - SQL Tuning/06 Index Suppression/quizzes/005 Index Suppression SQL.html |
1 KB |
| Udemy - SQL Tuning/06 Index Suppression/038 Function based Indexes.mp4 |
11.7 MB |
| Udemy - SQL Tuning/06 Index Suppression/034 Use of TRUNC function on Date columns.mp4 |
9.1 MB |
| Udemy - SQL Tuning/02 Optimizer and its Execution Plan/005 Cost based Optimization.mp4 |
8.9 MB |
| Udemy - SQL Tuning/02 Optimizer and its Execution Plan/007 Execution Plan.mp4 |
7 MB |
| Udemy - SQL Tuning/02 Optimizer and its Execution Plan/008 SQL Tuning Tools.mp4 |
7.9 MB |
| Udemy - SQL Tuning/02 Optimizer and its Execution Plan/009 Running Explain Plan.mp4 |
10.9 MB |
| Udemy - SQL Tuning/02 Optimizer and its Execution Plan/quizzes/002 Optimizer statistics.html |
4 KB |
| Udemy - SQL Tuning/02 Optimizer and its Execution Plan/006 Gathering Statistics.mp4 |
11.1 MB |
| Udemy - SQL Tuning/05 Simple Tuning Rules/027 SELECT consideration.mp4 |
7.1 MB |
| Udemy - SQL Tuning/05 Simple Tuning Rules/028 Using Table Aliases.mp4 |
6.6 MB |
| Udemy - SQL Tuning/05 Simple Tuning Rules/029 Using WHERE rather than HAVING.mp4 |
8.8 MB |
| Udemy - SQL Tuning/05 Simple Tuning Rules/quizzes/004 Simple Rules.html |
1 KB |
| Udemy - SQL Tuning/01 SQL Tuning Introduction/004 SOFT parse vs HARD parse.mp4 |
5.5 MB |
| Udemy - SQL Tuning/01 SQL Tuning Introduction/003 SQL Processing.mp4 |
9.7 MB |
| Udemy - SQL Tuning/01 SQL Tuning Introduction/002 Prerequisites for SQL Tuning.mp4 |
3.8 MB |
| Udemy - SQL Tuning/01 SQL Tuning Introduction/001 Why SQL Tuning.mp4 |
17.8 MB |
| Udemy - SQL Tuning/01 SQL Tuning Introduction/quizzes/001 Parsing.html |
4 KB |
| Udemy - SQL Tuning/08 Considerations while using SQL in programming/048 Using BULK COLLECT.mp4 |
8.2 MB |
| Udemy - SQL Tuning/08 Considerations while using SQL in programming/046 Reduce the number of Trips to the database.mp4 |
6.9 MB |
| Udemy - SQL Tuning/08 Considerations while using SQL in programming/047 Issue frequent COMMIT statements.mp4 |
4.6 MB |
| Udemy - SQL Tuning/07 Performance Improvement Considerations/043 Use EXISTS instead of DISTINCT.mp4 |
10.8 MB |
| Udemy - SQL Tuning/07 Performance Improvement Considerations/039 Use UNION instead of OR.mp4 |
11.2 MB |
| Udemy - SQL Tuning/07 Performance Improvement Considerations/042 EXISTS vs IN.mp4 |
5.6 MB |
| Udemy - SQL Tuning/07 Performance Improvement Considerations/040 Use UNION ALL instead of UNION.mp4 |
11.7 MB |
| Udemy - SQL Tuning/07 Performance Improvement Considerations/045 Use TRUNCATE instead of DELETE.mp4 |
12.3 MB |
| Udemy - SQL Tuning/07 Performance Improvement Considerations/044 Reading same table multiple times.mp4 |
19.6 MB |
| Udemy - SQL Tuning/07 Performance Improvement Considerations/041 Minimize Table lookups in a Query.mp4 |
12 MB |
Magnet link
