Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
>>
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only