Subject RE: [Firebird-Architect] RFC: Proposal for the implementation of Temporary Tables.
Author Ann W. Harrison
At 05:03 PM 11/23/2004, Samofatov, Nickolay wrote:


>I would simply add ATTACHMENT_ID system column (probably with
>appropriate index) to tables declared as temporary and taught optimizer
>to filter out rows which should not be visible by current attachment.

The more I think about it, the less I understand it. If you have
a temporary table with a primary key, is there an index for each
attachment or a single index for the table? Are you storing data
for all users on the same pages?

Regards,


Ann