Hi Craig,
Windy and boring, lol. I am sure your wife knows what I mean!
Chris
>Yes, indexing will definately help SQL SELECTs, but the search criteria has to exactly match the index. I explain this in more detail in the Rushmore article on my website.
>
>BTW, how are things in Lethbridge? My wife's family is from the area.
>
>>Hi,
>>
>>I have a very basic indexing question that I should probably know the answer to but I don't. I know that indexing is great for when using the seek command and things like that. But does indexing also speed up sql statements? Say we have a table called employee and have an index on "emp_no". Then we have an SQL statement, 'select * from employee where emp_no > "500"' If we had an index would the query run faster?
>>
>>Its not big deal, I was just curious.
>>
>>Chris
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