>>> Is there any way to automate the indexing? Kinda like a virtual "tag" index so I don't have to remember the indexes ever time? <<
>
>Hmmmm. I never really thought about it. I suppose that if you require lots of indexed views, you could data-drive it. Set up a lookup table with the view name, tag name, and index expression. The you could write some generic code that creates the index(es) on the specified expression if the view name is found in the table.
Thanks Marcia! I'll keep this in mind. I'm sure I'll be needing this because the app I'm about to start working on will require a gazillion different ways to view the data.
Alex
Low-carb diet not working? Try the Low-food diet instead!