| Subject | global temporary table and read only transaction |
|---|---|
| Author | Philippe Makowski |
| Post date | 2008-04-11T15:19:47Z |
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 ?
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 ?