General information
Title:
Basic Indexing Question
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
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