Re: That crazy CBO.....
- From: "Joel Garry" <joelgarry@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 29 Oct 2004 10:34:14 -0700
Jonathan Gennick wrote: >I'd argue that Oracle should fix it. One shouldn't have to >bother with something as cumbersome as 10046 trace just to >see an execution plan. I don't even like having to query the >plan table (or use dbms_xplan) from SQL*Plus. The front end >should do all that crud for me. Just MHO. You mean, like OEM? :) I smiley, but actually I use it all the time, even though explain plain sometimes lies like a dog. Yes, Oracle should fix all those things. Until Oracle fixes _all_ those things, any self-tuning-database marketspeak is suspect, to say the least. http://www.garry.to -- http://www.freelists.org/webpage/oracle-l