SQL Server Performance

Pulling data from Views

Discussion in 'Performance Tuning for DBAs' started by loiter99, Aug 15, 2005.

  1. loiter99 New Member

    Hello,
    I am pulling records via ODBC from a SQL server 2000 into an Access 2000 database. If I pull directly from a table the 9,000 odd records are transferred in 2 seconds. If I pull the same data through a view, the data is collected in 6 seconds, but the transfer time is 90 seconds. Does anyone have an explaination?

    Thanks
    Jeff
  2. satya Moderator

    Monitor the event with PROFILER and check the execution plan for that query.
    BTW are you using DTS?

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page