Udemy SQL Tuning | E58D29F69820B10CC2C3270FBAC31919777BC3C4

Udemy SQL Tuning

Name	Udemy - SQL Tuning	DOWNLOAD Copy Link Trouble downloading? see How To
Total Size	679.9 MB
Total Files	67
Hash	E58D29F69820B10CC2C3270FBAC31919777BC3C4

/10 HINTS to the database/
053 Why HINTS.mp4	18.9 MB
054 Forcing a specific Join Method.mp4	16.7 MB
055 HINTS list.pdf	213.6 KB
/11 House Keeping/
056 Invalid Optimizer Statistics.mp4	21.9 MB
057 Checking SQL statements which are performing BAD.mp4	22.9 MB
/09 Join Methods/
052 Sort Merge Join.mp4	14.3 MB
051 Hash Join.mp4	10.6 MB
049 Join Methods.mp4	3.6 MB
050 Nested Loop Join.mp4	20.0 MB
/12 Design Considerations/
059 Separate Tablespace for Data and Index.mp4	11.7 MB
060 Index Organized Tables.mp4	15.1 MB
058 Effective Schema Design.mp4	16.2 MB
061 Partitioned Tables.mp4	17.2 MB
062 Bitmap Indexes.mp4	18.8 MB
/03 Accessing Tables/
010 What is my Address.mp4	5.2 MB
016 Choosing between FULL and INDEX scan.mp4	4.8 MB
013 Table Access by ROWID.mp4	9.3 MB
015 Index Range Scan.mp4	11.2 MB
011 Types of Table Accesses.mp4	6.1 MB
014 Index Unique Scan.mp4	10.6 MB
012 Table Access FULL.mp4	8.1 MB
/quizzes/
003 Access Paths.html	3.8 KB
/04 Explain Plan/
017 Execution Plan.mp4	3.6 MB
023 Execution Plan Example 1.mp4	8.4 MB
018 What should you look for.mp4	12.2 MB
021 Traversing through the Tree.mp4	10.4 MB
026 Execution Plan Example 4.mp4	25.9 MB
024 Execution Plan Example 2.mp4	10.2 MB
022 Reading Execution Plan.mp4	10.2 MB
020 Rules of Execution Plan Tree.mp4	9.2 MB
019 What is COST.mp4	5.1 MB
025 Execution Plan Example 3.mp4	16.4 MB
/06 Index Suppression/
033 Use of Arithmetic operators.mp4	8.2 MB
030 Index Suppression reasons.mp4	4.8 MB
031 Use of operator.mp4	15.8 MB
035 Use of operator.mp4	7.3 MB
036 Comparing a character column to a numeric value.mp4	8.2 MB
037 Use of IS NULL and IS NOT NULL.mp4	10.9 MB
032 Use of SUBSTR function.mp4	10.0 MB
038 Function based Indexes.mp4	12.3 MB
034 Use of TRUNC function on Date columns.mp4	9.5 MB
/quizzes/
005 Index Suppression SQL.html	1.5 KB
/02 Optimizer and its Execution Plan/
005 Cost based Optimization.mp4	9.4 MB
007 Execution Plan.mp4	7.4 MB
008 SQL Tuning Tools.mp4	8.3 MB
009 Running Explain Plan.mp4	11.4 MB
006 Gathering Statistics.mp4	11.6 MB
/quizzes/
002 Optimizer statistics.html	4.4 KB
/05 Simple Tuning Rules/
027 SELECT consideration.mp4	7.5 MB
028 Using Table Aliases.mp4	6.9 MB
029 Using WHERE rather than HAVING.mp4	9.2 MB
/quizzes/
004 Simple Rules.html	1.5 KB
/01 SQL Tuning Introduction/
004 SOFT parse vs HARD parse.mp4	5.7 MB
003 SQL Processing.mp4	10.2 MB
002 Prerequisites for SQL Tuning.mp4	4.0 MB
001 Why SQL Tuning.mp4	18.7 MB
/quizzes/
001 Parsing.html	3.6 KB
/08 Considerations while using SQL in programming/
048 Using BULK COLLECT.mp4	8.6 MB
046 Reduce the number of Trips to the database.mp4	7.3 MB
047 Issue frequent COMMIT statements.mp4	4.8 MB
/07 Performance Improvement Considerations/
043 Use EXISTS instead of DISTINCT.mp4	11.3 MB
039 Use UNION instead of OR.mp4	11.8 MB
042 EXISTS vs IN.mp4	5.9 MB
040 Use UNION ALL instead of UNION.mp4	12.2 MB
045 Use TRUNCATE instead of DELETE.mp4	12.9 MB
044 Reading same table multiple times.mp4	20.6 MB
041 Minimize Table lookups in a Query.mp4	12.6 MB
Total files 67