589689.xyz

Pluralsight - MySQL Query Optimization and Performance Tuning With Pinal Dave

  • 收录时间:2021-08-08 02:20:03
  • 文件大小:352MB
  • 下载次数:1
  • 最近下载:2021-08-08 02:20:03
  • 磁力链接:
立即下载 复制链接

文件列表

  1. 04. Performance Optimization by Practical Query Tuning/10. Demo Tuning Aggregate Function.wmv 20MB
  2. 04. Performance Optimization by Practical Query Tuning/04. Demo One Complex Query vs Multiple Simple Queries - Part 2.wmv 17MB
  3. 04. Performance Optimization by Practical Query Tuning/03. Demo One Complex Query vs Multiple Simple Queries.wmv 17MB
  4. 04. Performance Optimization by Practical Query Tuning/08. Demo Most Optimal Choice - Subquery vs Exists vs Joins.wmv 16MB
  5. 02. Optimizing Data Access/07. Demo Why SELECT Star ( ) is Bad Idea.wmv 16MB
  6. 04. Performance Optimization by Practical Query Tuning/13. Demo Impact on Performance of UNION and UNION ALL.wmv 16MB
  7. 04. Performance Optimization by Practical Query Tuning/09. Demo Most Optimal Choice - Subquery vs Exists vs Joins - Part 2.wmv 16MB
  8. 04. Performance Optimization by Practical Query Tuning/07. Demo Table Order in Join Clause - OUTER JOIN.wmv 15MB
  9. 03. Understanding MySQL Query Optimization/17. Demo Explain Command.wmv 14MB
  10. 04. Performance Optimization by Practical Query Tuning/02. Demo Index Used for SELECT clause.wmv 14MB
  11. 05. Best Practices/01. Best Practices.wmv 13MB
  12. 04. Performance Optimization by Practical Query Tuning/12. Demo Optimizing Paging with LIMIT Clause.wmv 11MB
  13. 04. Performance Optimization by Practical Query Tuning/06. Demo Table Order in Join Clause - INNER JOIN.wmv 10MB
  14. 04. Performance Optimization by Practical Query Tuning/11. Demo Optimizing Group By Clause.wmv 10MB
  15. 04. Performance Optimization by Practical Query Tuning/05. Demo One Complex Query vs Multiple Simple Queries with Index.wmv 9MB
  16. 04. Performance Optimization by Practical Query Tuning/14. Demo Index and Not Equal to Operator.wmv 9MB
  17. 02. Optimizing Data Access/06. Demo Best Practices for Data Access.wmv 9MB
  18. 03. Understanding MySQL Query Optimization/15. Demo Show Full Processlist.wmv 8MB
  19. 03. Understanding MySQL Query Optimization/09. Query Optimizer Limitations.wmv 8MB
  20. 01. Introduction/01. Introduction.wmv 8MB
  21. 03. Understanding MySQL Query Optimization/18. Demo Explain Extended Command.wmv 7MB
  22. 02. Optimizing Data Access/04. Understanding Data Needs.wmv 7MB
  23. 03. Understanding MySQL Query Optimization/14. Understanding Query States.wmv 7MB
  24. 03. Understanding MySQL Query Optimization/03. Client Protocols.wmv 7MB
  25. materials/1-mysql-query-optimization-performance-tuning-m01-introduction-slides.pdf 6MB
  26. 03. Understanding MySQL Query Optimization/10. Query Execution Engine and Storage.wmv 5MB
  27. 03. Understanding MySQL Query Optimization/08. Query Optimizer Responsibilities.wmv 5MB
  28. 04. Performance Optimization by Practical Query Tuning/01. Introduction.wmv 5MB
  29. 03. Understanding MySQL Query Optimization/07. Query Optimizer.wmv 5MB
  30. 02. Optimizing Data Access/03. Overheard.wmv 4MB
  31. 02. Optimizing Data Access/01. Introduction.wmv 3MB
  32. 03. Understanding MySQL Query Optimization/04. Query Cache.wmv 3MB
  33. 03. Understanding MySQL Query Optimization/01. Introduction.wmv 3MB
  34. 03. Understanding MySQL Query Optimization/12. Additional Notes on Query Optimizer.wmv 3MB
  35. 03. Understanding MySQL Query Optimization/11. Returning Result to Client.wmv 3MB
  36. 02. Optimizing Data Access/02. Prerequisite.wmv 3MB
  37. 03. Understanding MySQL Query Optimization/05. Parser.wmv 2MB
  38. 02. Optimizing Data Access/05. Demo Setup.wmv 2MB
  39. 04. Performance Optimization by Practical Query Tuning/15. Summary in Sixty Seconds.wmv 2MB
  40. 03. Understanding MySQL Query Optimization/02. Execution Path of a Query.wmv 2MB
  41. 03. Understanding MySQL Query Optimization/13. Maximizing Query Optimizer Performance.wmv 2MB
  42. 03. Understanding MySQL Query Optimization/06. Preprocessor.wmv 2MB
  43. 03. Understanding MySQL Query Optimization/16. Understanding Explain Command.wmv 2MB
  44. 03. Understanding MySQL Query Optimization/19. Summary in Sixty Seconds.wmv 2MB
  45. 02. Optimizing Data Access/08. Summary in Sixty Seconds.wmv 1MB
  46. materials/3-mysql-query-optimization-performance-tuning-m03-slides.pdf 730KB
  47. materials/2-mysql-query-optimization-performance-tuning-m02-optimizing-data-access-slides.pdf 125KB
  48. materials/5-mysql-query-optimization-performance-tuning-m05-best-practices-slides.pdf 116KB
  49. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/6-Correlated.sql 4KB
  50. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/7-Correlated-2.sql 2KB
  51. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/11-Union-All-Union.sql 2KB
  52. materials/2-mysql-query-optimization-performance-tuning-m02-optimizing-data-access-exercise-files/before/1-script.sql 2KB
  53. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/2-Joins.sql 1KB
  54. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/09-GroupBy.sql 1KB
  55. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/4-Join Order.sql 1KB
  56. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/5-Join Order-Outer.sql 1KB
  57. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/8-Min-Max.sql 897B
  58. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/1-Index.sql 583B
  59. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/3-MultipleQuery.sql 554B
  60. materials/3-mysql-query-optimization-performance-tuning-m03-exercise-files/demo/before/1-longquery.sql 430B
  61. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/10-Limit-Offset.sql 300B
  62. materials/4-mysql-query-optimization-performance-tuning-m04-performance-optimization-exercise-files/demo/before/12-NEQ-Index.sql 261B
  63. materials/3-mysql-query-optimization-performance-tuning-m03-exercise-files/demo/before/2-showprocesslist.sql 21B