Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    1

    Exclamation Unanswered: Strange Indexed View Issue

    I got an issue with a product I am working on. I am running a query with multiple joins on an indexed view which does nothing but return a subset (1 years worth) of records from a very large (5 year) indexed table. However, the query on the indexed view takes longer to run than if I run it on the UNIndexed view returning the same subset from the same large table. I know it sounds wierd but are there any ideas on why querying an indexed view would take longer than querying an unindexed view?

    Thanks,
    Jason

  2. #2
    Join Date
    Aug 2003
    Location
    Andover, MA
    Posts
    256
    Make sure the tables underlying the view are indexed properly. It sounds like the joins that are slowing you down.
    -bpd

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •