Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
He's already said he can't use p-views.
>>>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!
>>
>>Not create indexes on the fly. The index list will be set on the fly based on the index. SET KEY I believe would workable. But, I'm not familiar with it, so it will take more time to implement.
>
>You can easily create indexes on the fly, and still have reasonable performance, if you use a parameterized view to get the required data.
>
>The index will only be created on the data you have fetched.
>
>SET KEY doesn't give you this flexibility. Sure, you can create compound indexes, but you will require several of those, to cover all cases.
Précédent
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