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 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
