演示 SQL 调优策略的测试场景
有没有地方可以找到测试用例来说明不同的 SQL 调优策略？例如，如果表上的聚类因子不好并且 Oracle 执行表扫描而不是索引访问，我希望有一个包含所需数据的测试场景来演示不良聚类。 类似的场景来说明错误的连接顺序、分区和其他调整主题将非常有帮助。
Is there a place where we can find test cases to illustrate different SQL tuning strategies? For example if the clustering factor on a table is bad and oracle performs a table scan instead of index access I would like to have a test scenario with required data to demonstrate the bad clustering.
Similarly scenarios to illustrate wrong join order, partitioning and other tuning topics would be very helpful.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可能会发现的最接近的内容是 Jonathan Lewis 编写的有关这些主题的大量测试。
我会去访问并搜索他的博客：http://jonathanlewis.wordpress.com/
和/或购买他的书：http://www.jlcomp.demon.co。 uk/cbo_book/ind_book.html
例如，关于聚类因子的第一个问题已在本书第 5 章中介绍，您可以查看预览这里
问候，
抢。
The closest thing you'll probably find are the numerous tests Jonathan Lewis has written about these topics.
I'd go visit and search his blog: http://jonathanlewis.wordpress.com/
and/or buy his book: http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
For example your first question about the clustering factor is covered in chapter 5 of this book, of which you can see a preview here
Regards,
Rob.
Tom Kyte 在他的网站上有许多很好的完整示例： http:// Asktom.oracle.com/pls/apex/f?p=100:1:0
尽管您必须将它们从讨论线程中挖掘出来
Tom Kyte has many good complete examples on his site: http://asktom.oracle.com/pls/apex/f?p=100:1:0
Although you'll have to dig them out of the discussion threads