Roman Rokytskyy [08-04-11 20.04] :

>> now, if you are inside a read only transaction, you can't insert data into a GTT
>> but GTT are useful to some long running select queries or even to make a set of successive
>> select queries
>> since GTT have a flag and that data are outside the db file, wouldn't be possible to allow
>> insert even on read only transaction ?
>
> What is the use case for such requirement?
>

For example statistical calculation on sample extracted from bigger table such median,
quartile, decile, ...
we don't have RANK() function yet