It's still really odd behavior. I ended up installing sp2 on sql server and now they both run around 20 minutes. I guess there was an execution plan that had been cached on the "select *" query. Interestingly enough, myView is made up of two other views bound with a left join. Both of those views run about 3 seconds. I even found out that when I change the left join to an inner join, the query runs 10 secs.
Oh how I wish I was using Oracle again!! 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 >> >> >> >> >> >> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
