From EvaD@TFMC.co.za Mon, 21 Jan 2002 06:25:08 -0800 From: Denham Eva Date: Mon, 21 Jan 2002 06:25:08 -0800 Subject: Optimize Method Q? Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: Optimize Method Q? Hello Folks, Ok, I know that I have alot to learn, but when you do something believing that it will speed up things and it does but only for "some queries" and turns others into instant snales, a newbie like me really wonders. The situation is like this, I analyzed all the relevant schema's tables and indexes. Now one of the more important queries( a long one) just turned from a tortois into a snale. I have been forced to set the database optimizer method to rule. Which has had the effect of turning the snale back to a tortois. The system is a 8.1.7 on a Windows 2000 machine. Optimization was CHOOSE, but because the tables were not analyzed it invariably chose rule. The only "strange" observation I can make is that the developers have three indexes on this table, with three columns in all three indexes, but in different positions. Any comments on why this would happen/how this happens. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com