种子简介

种子名称： Udemy - SQL Tuning
文件类型： 视频
文件数目： 61个文件
文件大小： 648.2 MB
收录时间： 2016-7-30 12:44
已经下载： 3次
资源热度： 127
最近下载： 2024-12-4 15:56

下载BT种子文件

下载Torrent文件(.torrent) 立即下载

磁力链接下载

magnet:?xt=urn:btih:e58d29f69820b10cc2c3270fbac31919777bc3c4&dn=Udemy - SQL Tuning 复制链接到迅雷、QQ旋风进行下载，或者使用百度云离线下载。

喜欢这个种子的人也喜欢

种子包含的文件

Udemy - SQL Tuning.torrent

10 HINTS to the database/053 Why HINTS.mp417.99MB

10 HINTS to the database/054 Forcing a specific Join Method.mp415.92MB

11 House Keeping/056 Invalid Optimizer Statistics.mp420.84MB

11 House Keeping/057 Checking SQL statements which are performing BAD.mp421.86MB

09 Join Methods/052 Sort Merge Join.mp413.67MB

09 Join Methods/051 Hash Join.mp410.16MB

09 Join Methods/049 Join Methods.mp43.39MB

09 Join Methods/050 Nested Loop Join.mp419.08MB

12 Design Considerations/059 Separate Tablespace for Data and Index.mp411.2MB

12 Design Considerations/060 Index Organized Tables.mp414.41MB

12 Design Considerations/058 Effective Schema Design.mp415.4MB

12 Design Considerations/061 Partitioned Tables.mp416.39MB

12 Design Considerations/062 Bitmap Indexes.mp417.89MB

03 Accessing Tables/010 What is my Address.mp44.98MB

03 Accessing Tables/016 Choosing between FULL and INDEX scan.mp44.54MB

03 Accessing Tables/013 Table Access by ROWID.mp48.84MB

03 Accessing Tables/015 Index Range Scan.mp410.71MB

03 Accessing Tables/011 Types of Table Accesses.mp45.83MB

03 Accessing Tables/014 Index Unique Scan.mp410.09MB

03 Accessing Tables/012 Table Access FULL.mp47.71MB

04 Explain Plan/017 Execution Plan.mp43.42MB

04 Explain Plan/023 Execution Plan Example 1.mp48MB

04 Explain Plan/018 What should you look for.mp411.64MB

04 Explain Plan/021 Traversing through the Tree.mp49.9MB

04 Explain Plan/026 Execution Plan Example 4.mp424.72MB

04 Explain Plan/024 Execution Plan Example 2.mp49.68MB

04 Explain Plan/022 Reading Execution Plan.mp49.69MB

04 Explain Plan/020 Rules of Execution Plan Tree.mp48.73MB

04 Explain Plan/019 What is COST.mp44.82MB

04 Explain Plan/025 Execution Plan Example 3.mp415.61MB

06 Index Suppression/033 Use of Arithmetic operators.mp47.86MB

06 Index Suppression/030 Index Suppression reasons.mp44.61MB

06 Index Suppression/031 Use of operator.mp415.08MB

06 Index Suppression/035 Use of operator.mp46.94MB

06 Index Suppression/036 Comparing a character column to a numeric value.mp47.77MB

06 Index Suppression/037 Use of IS NULL and IS NOT NULL.mp410.36MB

06 Index Suppression/032 Use of SUBSTR function.mp49.5MB

06 Index Suppression/038 Function based Indexes.mp411.73MB

06 Index Suppression/034 Use of TRUNC function on Date columns.mp49.07MB

02 Optimizer and its Execution Plan/005 Cost based Optimization.mp48.93MB

02 Optimizer and its Execution Plan/007 Execution Plan.mp47.01MB

02 Optimizer and its Execution Plan/008 SQL Tuning Tools.mp47.95MB

02 Optimizer and its Execution Plan/009 Running Explain Plan.mp410.86MB

02 Optimizer and its Execution Plan/006 Gathering Statistics.mp411.09MB

05 Simple Tuning Rules/027 SELECT consideration.mp47.13MB

05 Simple Tuning Rules/028 Using Table Aliases.mp46.62MB

05 Simple Tuning Rules/029 Using WHERE rather than HAVING.mp48.77MB

01 SQL Tuning Introduction/004 SOFT parse vs HARD parse.mp45.45MB

01 SQL Tuning Introduction/003 SQL Processing.mp49.68MB

01 SQL Tuning Introduction/002 Prerequisites for SQL Tuning.mp43.85MB

01 SQL Tuning Introduction/001 Why SQL Tuning.mp417.82MB

08 Considerations while using SQL in programming/048 Using BULK COLLECT.mp48.23MB

08 Considerations while using SQL in programming/046 Reduce the number of Trips to the database.mp46.94MB

08 Considerations while using SQL in programming/047 Issue frequent COMMIT statements.mp44.61MB

07 Performance Improvement Considerations/043 Use EXISTS instead of DISTINCT.mp410.76MB

07 Performance Improvement Considerations/039 Use UNION instead of OR.mp411.22MB

07 Performance Improvement Considerations/042 EXISTS vs IN.mp45.64MB

07 Performance Improvement Considerations/040 Use UNION ALL instead of UNION.mp411.65MB

07 Performance Improvement Considerations/045 Use TRUNCATE instead of DELETE.mp412.29MB

07 Performance Improvement Considerations/044 Reading same table multiple times.mp419.65MB

07 Performance Improvement Considerations/041 Minimize Table lookups in a Query.mp412.03MB