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
Index View
2 posts • Page 1 of 1
Index View
by tim neerdaels on Mon Dec 14, 2009 5:29 am
- tim neerdaels
- Posts: 2
- Joined: Sun Nov 16, 2008 8:00 am
Re: Index View
by shermang on Wed Mar 10, 2010 9:22 am
Hey Tim,
SQL Server always makes the decision as to what index to use when doing a query of the database.
SQL Server always makes the decision as to what index to use when doing a query of the database.
Sherman Glass
Software Professionals, Inc.
No longer working directly for Jet Reports, but still loving it.
Software Professionals, Inc.
No longer working directly for Jet Reports, but still loving it.
-
shermang - Site Admin
- Posts: 165
- Joined: Tue Sep 25, 2007 7:41 am
- Location: Portland, Oregon, USA
2 posts • Page 1 of 1
Who is online
Users browsing this forum: No registered users and 1 guest