Well the fact that you are joining two views might have something to do with it...why not bypass the whole view routine and build a new view altogether, and see if that fixes it?
Maybe it's just me, but joining views seems counter to the purpose of a view anyway. -- jon mailto:[EMAIL PROTECTED] Tuesday, December 3, 2002, 11:28:42 AM, you wrote: MM> It's still really odd behavior. I ended up installing sp2 on sql server MM> and now they both run around 20 minutes. I guess there was an execution MM> plan that had been cached on the "select *" query. Interestingly MM> enough, myView is made up of two other views bound with a left join. MM> Both of those views run about 3 seconds. I even found out that when I MM> change the left join to an inner join, the query runs 10 secs. MM> Oh how I wish I was using Oracle again!! MM> Harkins,Patrick wrote: >>Maybe it doesn't like being called a dummy? :-) Seriously tho, did you get >>it figured out? >>-Patrick >> >> >> >>>-----Original Message----- >>>From: Marlon Moyer [mailto:[EMAIL PROTECTED]] >>>Sent: Monday, December 02, 2002 6:02 PM >>>To: CF-Community >>>Subject: SQL Wackiness >>> >>> >>>This is really, really weird MS SQL Server 2000 behavior. >>> >>>I have a view on the server that when I run this query: >>> >>>SELECT * FROM myView >>> >>>It takes about 18 seconds >>> >>>When I run this query: >>> >>>SELECT Dummycol, DummyCol2, DummyCol3 FROM myView >>> >>>It takes 20 minutes!!!! >>> >>>Has anyone else seen this behavior? >>> >>>Marlon >>> >>> >>> >>> >>> >>> >> MM> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
