Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Craig, I meant to cc you on this...
>Craig,
>
>BTW, I've seen you on the UT pretty early for EST. And it's 2 hours earlier in Utah. Trouble sleeping? :-)
>
>Renoir
>
>>Craig,
>>
>>That's cool. I'm going to have to go back now and check how I'm retrieving information in my views for editing and reporting... Thanks!
>>
>>Renoir
>>
>>>Have a few indexes on most used queries. For example, Primary Key, Customer Number, Name, State, etc. Run a query using those indeces. Then if you need to limit the information by something that you don't have an index on, say by a particular zip code, query this intermediate table. Because you are looking at a smaller set of data, the non-indexed query should be faster.
>>>
>>>>
>>>>Craig,
>>>>
>>>>You said "...retrieving a subset using the index..." What do you mean exactly?
>>>>
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