Beware of the Beast, aka "Axis", aka "MS Access". Yesterday a user called to have his Axis query killed because it had been running 10 minutes when it should only take about a second. After snooping the SQL, Axis was sending separate SQL statements for each table (in two different sessions), and was running these for each row in one of his local Axis tables that the query was joined to. I asked him to move the 20 rows of his Axis table to the criteria part of the Oracle column it was joined to and it returned subsecond. And the query looked about as good as could be expected from Axis.
Evil, evil, evil. Axis of Evil. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -----Original Message----- Sent: Friday, February 28, 2003 8:19 AM To: Multiple recipients of list ORACLE-L Precisely. In our environment, great care is taken with adding/modifying data. But when it comes to reporting, there's no standardization of products or concern about what's being reported. The DBA's find out about a bad query when it hits the "this sql really sucks" list (or when the whining starts). You'd think damagement would learn. It's more than just concerns about performance issues. Wouldn't you think damagement would care about the accuracy of data being reported?? I'm really starting to warm up to the configurable version of the sending rasberries product. When is that going to be available?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).