Blogs about: Execution Plans
Featured Blog
Sorted Hash Clusters
Towards the end of April, I published a note about manual optimisation, and mentioned in one of the comments (#19) that as part of the discussion of the (slightly suspect) mechanism I had introduced… more »
Oracle Scratchpad
Sorted Hash Clusters
— 9 comments
Jonathan Lewis wrote 1 week ago: Towards the end of April, I published a note about manual optimisation, and mentioned in one of th … more »
Constant Scan in Execution Plans
scarydba wrote 3 weeks ago: I see a lot of searches from people apparently trying to find out what having a Constant Scan in the … more »
Break Down Complex Execution Plans
— 1 comment
scarydba wrote 1 month ago: I’ve seen this question posted in a lot places and I’ve seen the search come in to the b … more »
XML Showplan in 2008
scarydba wrote 1 month ago: I just found my first fundamental difference between execution plans in SQL Server 2005 and SQL Serv … more »
Dissecting Execution Plans: Chapter 1
scarydba wrote 2 months ago: Tony posted the first chapter of the book over at Simple Talk. Now you can be cheap and decide if yo … more »
Manual Optimisation
— 32 comments
Jonathan Lewis wrote 2 months ago: [Forward to Manual Optimisation part 2] Warning: The following note supplies an example of a mechani … more »
Cardinality Change
Jonathan Lewis wrote 2 months ago: Here’s an interesting point that’s just been raised on from the Oracle-L list-server: Me … more »
Everything Changes
— 6 comments
Jonathan Lewis wrote 4 months ago: Sometimes you look at a change in the optimizer arithmetic and think “Why did that take so lon … more »
Cursor_sharing
— 4 comments
Jonathan Lewis wrote 4 months ago: From time to time I’ve commented on the fact that setting cursor_sharing to force or similar m … more »
dbms_xplan(3)
— 7 comments
Jonathan Lewis wrote 4 months ago: Some time ago, I wrote a note about using the packaged function dbms_xplan.display_cursor(). I … more »
IOTs and 10053
— 5 comments
Jonathan Lewis wrote 4 months ago: I’ve probably got a couple of comments about 10053 trace files lurking somewhere on this blog … more »
Pushing Predicates
— 6 comments
Jonathan Lewis wrote 5 months ago: Some time ago I wrote a note (on my website) about the push_pred() and no_push_pred() hints. I … more »
dbms_stats surprise
— 5 comments
Jonathan Lewis wrote 5 months ago: It’s been several years since I started telling people that one of the solutions to dealing wi … more »
Trouble-shooting
— 11 comments
Jonathan Lewis wrote 6 months ago: A recent item on one of the Oracle forums posed a question about copying statistics from one databas … more »
Filter plan error
— 1 comment
Jonathan Lewis wrote 6 months ago: In 10g, the code to generate execution plans changed dramatically, as did the SQL used by the dbms_x … more »
Scalar Subqueries
— 1 comment
Jonathan Lewis wrote 9 months ago: Here’s a question that recently appeared on the Oracle-L listserver. For the plan, the cost of … more »
Version Dependency
Jonathan Lewis wrote 1 year ago: Here’s a very simple query, hinted to follow a particular execution plan. select /*+ ordered … more »
Graphic Plans
— 2 comments
Jonathan Lewis wrote 1 year ago: A little while ago, in a blog about the order of operations in an execution plan, the follow-up disc … more »
How parallel
— 5 comments
Jonathan Lewis wrote 1 year ago: Or as Doug Burns put it on his blog: how can I tell the actual DOP used for my parallel query” … more »
Have your say. Start a blog.
See our free features »
Copyright 2008 Automattic, Inc.
An 
Ruckus
