0

Index View

Jet Reports Historic Posts

December 14, 2009 17:58

None

Follow

Index View
by tim neerdaels on Mon Dec 14, 2009 5:29 am

Where does the use of an indexedview get decided.

1) Jet Reports level
2) c/front level
3) sql server level

Is there a way to force use of an indexed view?

Tim

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts December 14, 2009 19:03

  Tim,
  
  I'm not 100% sure of what you mean by "Indexedview", but, assuming you mean Index or Key, then the following is true.
  
  When working with a Navision Database on SQL Server. Jet Reports looks at the filters and sorting applied in the NL() function to make a best attempt to pick a key. This key selection is passed to C/Front and a request is made of the database. However, SQL Server then re-evaluates the filters and may change what key is actually used.
  
  So the answer is Jet Reports and then SQL Server with SQL Server having the final authority in the use of the Key.