Garrett Fitzgerald wrote: > On Fri, Oct 10, 2008 at 13:56, MB Software Solutions General Account > <[EMAIL PROTECTED]> wrote: >> What is the optimization plan showing? (...Using EXPLAIN or whatever >> the equivalent is in PL/SQL. It's been a long time for me...late >> 2004/early 2005 for that. Liked it better than T-SQL though!) > > Actually, it's showing the cost as only 178, which is amazingly low, > considering some of the reports I've been running lately. > > I highly recommend Oracle's SQL Developer tool if you have to write > queries against Oracle: it does a good job of reporting out the > Explain Plan and AutoTrace in an easy-to-read format. Just wish its > Intellisense didn't suck so badly... > > http://www.oracle.com/technology/products/database/sql_developer/index.html
I can't recall the tool I used before but it was a 3rd party tool for Oracle P/L SQL and iirc it was pretty good. _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
