Re: Query performance dramatically different

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 2 Feb 2006 11:27:36 -0800
Message-ID: <1138908455.983730.327650@g14g2000cwa.googlegroups.com>

Duscan, did you check for parameters set via database event logon triggers? For two different users to get different plans for the same SQL on the same DB logically something has to be different: cursor_sharing? Bind variable peeking?

I notice that the actual SQL did not appear in the thread so are there any constants in the SQL? Are both examples using the same constant values? If the data is skewed changing the constants could change the plan.

Problems like this can drive you nuts (assuming that DBA's are not already there anyway).

HTH -- Mark D Powell -- Received on Thu Feb 02 2006 - 13:27:36 CST