589689.xyz

Udemy - SQL Tuning

  • 收录时间:2018-03-17 04:22:10
  • 文件大小:648MB
  • 下载次数:238
  • 最近下载:2021-01-13 17:51:44
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 04 Explain Plan/026 Execution Plan Example 4.mp4 25MB
  2. 11 House Keeping/057 Checking SQL statements which are performing BAD.mp4 22MB
  3. 11 House Keeping/056 Invalid Optimizer Statistics.mp4 21MB
  4. 07 Performance Improvement Considerations/044 Reading same table multiple times.mp4 20MB
  5. 09 Join Methods/050 Nested Loop Join.mp4 19MB
  6. 10 HINTS to the database/053 Why HINTS.mp4 18MB
  7. 12 Design Considerations/062 Bitmap Indexes.mp4 18MB
  8. 01 SQL Tuning Introduction/001 Why SQL Tuning.mp4 18MB
  9. 12 Design Considerations/061 Partitioned Tables.mp4 16MB
  10. 10 HINTS to the database/054 Forcing a specific Join Method.mp4 16MB
  11. 04 Explain Plan/025 Execution Plan Example 3.mp4 16MB
  12. 12 Design Considerations/058 Effective Schema Design.mp4 15MB
  13. 06 Index Suppression/031 Use of operator.mp4 15MB
  14. 12 Design Considerations/060 Index Organized Tables.mp4 14MB
  15. 09 Join Methods/052 Sort Merge Join.mp4 14MB
  16. 07 Performance Improvement Considerations/045 Use TRUNCATE instead of DELETE.mp4 12MB
  17. 07 Performance Improvement Considerations/041 Minimize Table lookups in a Query.mp4 12MB
  18. 06 Index Suppression/038 Function based Indexes.mp4 12MB
  19. 07 Performance Improvement Considerations/040 Use UNION ALL instead of UNION.mp4 12MB
  20. 04 Explain Plan/018 What should you look for.mp4 12MB
  21. 07 Performance Improvement Considerations/039 Use UNION instead of OR.mp4 11MB
  22. 12 Design Considerations/059 Separate Tablespace for Data and Index.mp4 11MB
  23. 02 Optimizer and its Execution Plan/006 Gathering Statistics.mp4 11MB
  24. 02 Optimizer and its Execution Plan/009 Running Explain Plan.mp4 11MB
  25. 07 Performance Improvement Considerations/043 Use EXISTS instead of DISTINCT.mp4 11MB
  26. 03 Accessing Tables/015 Index Range Scan.mp4 11MB
  27. 06 Index Suppression/037 Use of IS NULL and IS NOT NULL.mp4 10MB
  28. 09 Join Methods/051 Hash Join.mp4 10MB
  29. 03 Accessing Tables/014 Index Unique Scan.mp4 10MB
  30. 04 Explain Plan/021 Traversing through the Tree.mp4 10MB
  31. 04 Explain Plan/022 Reading Execution Plan.mp4 10MB
  32. 04 Explain Plan/024 Execution Plan Example 2.mp4 10MB
  33. 01 SQL Tuning Introduction/003 SQL Processing.mp4 10MB
  34. 06 Index Suppression/032 Use of SUBSTR function.mp4 10MB
  35. 06 Index Suppression/034 Use of TRUNC function on Date columns.mp4 9MB
  36. 02 Optimizer and its Execution Plan/005 Cost based Optimization.mp4 9MB
  37. 03 Accessing Tables/013 Table Access by ROWID.mp4 9MB
  38. 05 Simple Tuning Rules/029 Using WHERE rather than HAVING.mp4 9MB
  39. 04 Explain Plan/020 Rules of Execution Plan Tree.mp4 9MB
  40. 08 Considerations while using SQL in programming/048 Using BULK COLLECT.mp4 8MB
  41. 04 Explain Plan/023 Execution Plan Example 1.mp4 8MB
  42. 02 Optimizer and its Execution Plan/008 SQL Tuning Tools.mp4 8MB
  43. 06 Index Suppression/033 Use of Arithmetic operators.mp4 8MB
  44. 06 Index Suppression/036 Comparing a character column to a numeric value.mp4 8MB
  45. 03 Accessing Tables/012 Table Access FULL.mp4 8MB
  46. 05 Simple Tuning Rules/027 SELECT consideration.mp4 7MB
  47. 02 Optimizer and its Execution Plan/007 Execution Plan.mp4 7MB
  48. 08 Considerations while using SQL in programming/046 Reduce the number of Trips to the database.mp4 7MB
  49. 06 Index Suppression/035 Use of operator.mp4 7MB
  50. 05 Simple Tuning Rules/028 Using Table Aliases.mp4 7MB
  51. 03 Accessing Tables/011 Types of Table Accesses.mp4 6MB
  52. 07 Performance Improvement Considerations/042 EXISTS vs IN.mp4 6MB
  53. 01 SQL Tuning Introduction/004 SOFT parse vs HARD parse.mp4 5MB
  54. 03 Accessing Tables/010 What is my Address.mp4 5MB
  55. 04 Explain Plan/019 What is COST.mp4 5MB
  56. 08 Considerations while using SQL in programming/047 Issue frequent COMMIT statements.mp4 5MB
  57. 06 Index Suppression/030 Index Suppression reasons.mp4 5MB
  58. 03 Accessing Tables/016 Choosing between FULL and INDEX scan.mp4 5MB
  59. 01 SQL Tuning Introduction/002 Prerequisites for SQL Tuning.mp4 4MB
  60. 04 Explain Plan/017 Execution Plan.mp4 3MB
  61. 09 Join Methods/049 Join Methods.mp4 3MB
  62. 10 HINTS to the database/055 HINTS list.pdf 209KB
  63. 02 Optimizer and its Execution Plan/quizzes/002 Optimizer statistics.html 4KB
  64. 03 Accessing Tables/quizzes/003 Access Paths.html 4KB
  65. 01 SQL Tuning Introduction/quizzes/001 Parsing.html 4KB
  66. 06 Index Suppression/quizzes/005 Index Suppression SQL.html 1KB
  67. 05 Simple Tuning Rules/quizzes/004 Simple Rules.html 1KB