Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
That'll work, but bear in mind you'll need a new set of indexes per office. You'll pay for that later in that it will take more time to reindex/re-create indexes, and record updates will have to updated those indexes.
SET KEY would be better for this scenario. Views/SPT would be ideal. I don't see how you not knowing SET KEY relates to the budget. You bill your client for time you spend learning?
>It should be set index list based on the office selected.
>
>>>
>>>Unfortunately at this time all we really have budget for is a quick and dirty solution using filtered indexes and changing indexes on the fly.
>>>
>>
>>What do you mean? You're going to create indexes on the fly? That's dirty and definitely not quick. SET KEY will knock your socks off!
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement