>
> Some of these "limits" boggle the mind. I can understand a limit

dealing with

> 4294967296/2147483648 at this point in the game, but where does 48k

come from?

Remembering the words of a man with some amazing <cough> insight, no-
one would ever need more than 64K, so to use 75% of it for the plan ....

Seriously though you can check the source to find out why. My guess is
that there is something else limited to 64K, of which 16K is already
allocated or reserved or something. Who knows, who cares.

A good way to make a huge plan is to use something like

select *
from table
where ID in (1,2,3,4,5,6,....,499,500)

It will hit the index for every member of the IN set. The Between
operator should be preferred where possible (such as the above case).

select *
from table
where ID between 1 and 500

It should be possible to simplify the plan though to avoid the error.

Adam