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