|Subject||RE: [firebird-support] Digest Number 9396|
> 1. I create those temporary tables for one user only, for one transaction only,All of that is already supported by temporary tables -- each connection creates a **separate instance** of the GTT, so connections never see other data.
> not visible for other users. I keep a track (log) of those tables and delete
> when I exit the program (drop table).
The GTT data is deleted/dropped when the Transaction commits (default) or when db connection is closed.
> 2. the use of index is deliberately blocked, I want to do it this way, my query"Blocked" why?
> is faster.