Post reply

Distributed partitioned views

  • December 8, 2004 at 3:05 am

    #60024

    I have created a distributed partitioned view using three tables

    when i query the view using the operator '=' i could see (through execution plans) the query engine directly

    queries the table in which the data is found

    but when i use the any other operator the query engine seems to query through all the three table even when

    the specified data range is found in a single table

    what could be the reason for this?

    what should i do to rectify this?

    please help

    Thanks in advance

    Siva

     

  • December 8, 2004 at 9:32 am

    #533069

    What other operators are you using? Do you have the same indexes on all three tables? It's possible there is a bug here. The distributed views are a 1.0 feature in SQL 2000.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply