Subject | RE: [Firebird-Architect] RFC: Proposal for the implementation of Temporary Tables. |
---|---|
Author | Ann W. Harrison |
Post date | 2004-11-23T23:13:08Z |
At 05:03 PM 11/23/2004, Samofatov, Nickolay wrote:
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
>I would simply add ATTACHMENT_ID system column (probably withThe more I think about it, the less I understand it. If you have
>appropriate index) to tables declared as temporary and taught optimizer
>to filter out rows which should not be visible by current attachment.
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