Hello, I posted this in the SQL message board as well, but I figure it could be answered here as well.<BR><BR>I have created a view on my database and create an index on the view to try to speed queries up.<BR><BR>I then query the view from my web app and it times out. I used the SQL Profiler to see if the Index was being used, and from the application it is not. When I test the exact same query from Query Analyzer it runs great and uses the Index.<BR><BR>I am using a DSN-less connection and thought that might be the problem, so I setup an ODBC connection, and still had the same problem.<BR><BR>Why would the web application use the View differently than running the same query from Query Analyzer?<BR><BR>Thanks<BR><BR>Clint