SETLL for SQL???
Its kind of like visiting relatives. If you want to visit your first cousins 10 records from where you are, then Fetch Relative 10 will work great. But, if you are trying to visit your long lost aunt on the other side of the database, Fetch Relative 10,000 will be a long and painful experience. Fetch Before and Fetch After, are quick ways to jump to either the beginning or the end of the result set, but unfortunately jumping any where else in the result set requires a painfuly slow search. So go ahead and use Fetch Relative to support Page Up and Page Down, but don't rely on it to perform "position to" type logic.
Its kind of like visiting relatives. If you want to visit your first cousins 10 records from where you are, then Fetch Relative 10 will work great. But, if you are trying to visit your long lost aunt on the other side of the database, Fetch Relative 10,000 will be a long and painful experience. Fetch Before and Fetch After, are quick ways to jump to either the beginning or the end of the result set, but unfortunately jumping any where else in the result set requires a painfuly slow search. So go ahead and use Fetch Relative to support Page Up and Page Down, but don't rely on it to perform "position to" type logic.
Comment