mit-offset are used in general queries (hand-crafted or
programe-generated) and it is not very realistic to rewrite all of them
into an offset-inside-subquery form.
Bing
David G. Johnston 于2020年12月7日周一 上午12:05写道：
> On Sunday, December 6, 2020, 孙冰 wrote:
>
>> The skipped rows by an OF
The skipped rows by an OFFSET clause have to be computed nevertheless. I am
wondering if there could be any chance to improve, since the computation is
on the *entire* rows rather than on the *criterial* columns.
Consider the following example.
Create a sample table and insert some random data.
