SQL Server Performance

Query taking extra time

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by amitsvyadav, Nov 7, 2008.

  1. amitsvyadav New Member

    Hi,
    I have a table in which there are 100 million rows and 2 supporting table, also have same amount of records.
    Now, I have created a view to get all related information but it is taking 50-60 mins to querying the data from the view.
    please advice waht to do so that i can get data in quickly from my view.
    Thanks,
    Amit
  2. FrankKalis Moderator

    Please post the code and the structure of the underlying tables. I would guess that you're missing a where clause and probably some indices.

Share This Page