Index View Error - Hint 'noexpand' on object is invalid

• Aparna-1

  SSCrazy

  Points: 2339

  More actions

  September 14, 2010 at 10:45 pm

  #226882

  Hi,

  I craeted an indexed view which is based on aggregates of the base table.

  When I checked the execution plan, the optimiser was ignoring the indexed view, there fore I used the NOEXPAND HINT Clause in my query.

  Modifiying the view resulted in the index being dropped and the query returned the error:

  Hint 'noexpand' on object

  When I am modying an indexed view why don't I get a warning that the index on the view might be dropped.

  Is this an indexed view bug and if so should I restrain from using NOEXPAND?

• Aparna-1

  SSCrazy

  Points: 2339

  More actions

  September 15, 2010 at 11:06 pm

  #1221891

  I googled without much luck.

  If Anybody can provide some pointers as to what could be causing this issue