Mike Yearwood
Toronto, Ontario, Canada
Yes, that's pretty basic <g>. Rushmore is probably the most important thing in fox. Look up optimization in the docs. BTW using > with character strings may not give the results you're looking for.
>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
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