The 3-Minute Test: What do you know about SQL performance?
来源:互联网 发布:mac虚拟机用速录笔 编辑:程序博客网 时间:2024/06/06 02:51
http://use-the-index-luke.com/3-minute-test
The 3-Minute Test: What do you know about SQL performance?
“SQL-Tuning is black magic like alchemy:it consists of obscure rules,understood only by a handfulof insiders.”
That is a myth. SQL databases use well-known algorithms to deliver predictable performance. It is, however, easy to write SQL queries that cannot use the most efficient algorithm and thus deliver unexpected performance.
The following questions provide examples that might make you believe that SQL tuning is black magic. The explanations at the end are just a few sentences long and reveal that the black magic is pure science.
Choose your Database
MySQLOracle PostgreSQL SQL Server
0 0
- The 3-Minute Test: What do you know about SQL performance?
- What do you need to know about localization?
- Man,what do you know?
- What You Should Know about The H.265 Video Codec
- What you should know about salary plateau
- What You Should Know About Floats
- do you know What is RFID?
- What are the open source code search engines you know about
- How Much Do You Know About 100G DWDM Transceiver?
- What you may need to know about DBTransaction::postChanges()
- What you need to know about BVT (Build Verification Testing)
- What you may not know about PHP session
- What do we know?
- Do you know solar?
- do you know?
- Do YOU know Resque?
- Do You Know ETL ?
- Unicode: What You Can Do About It Today
- html5 autofocus form formaction 新属性 例子
- Win32SDK基本 RC资源的使用
- 前端工程师知识结构
- 黑盒测试内容概述
- 打包contrail-setup
- The 3-Minute Test: What do you know about SQL performance?
- 苹果新的编程语言 Swift 语言进阶(四)--字符串和收集类型 (http://blog.csdn.net/goohong/article/details/30512483)
- 扒一扒计算机、机器学习相关资料
- [转载]ImageView图片宽度为控件宽度,高度按比例缩放
- Hibernate学习笔记之Blob存储
- 2012年12月10日SAT数学每日一练
- tomcat启动问题
- [stackoverflow]哈希表是如何工作的?
- C++ Primer 学习笔记_6_标准库类型 -- 命名空间using与string类型