Walter Meester
HoogkarspelNetherlands
Rod,
>FWIW, the SQL Select command based on a key value will perform as fast as a seek command.
>Take a look at foxforum.com
I have a real trouble believing this when knowing how this is implemented. Fact is that in any SQL server database the external scheme is seperated from its implementation. The seek is a very effictive command by directly using the index without relying on an optimizer and its overhead.
>Click on the last 3, 7 or 30 days option. It's actually calling this for each topic that comes up
I will do a test myself when I´ve got the time and report it up here.
Walter
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