> 1. I create those temporary tables for one user only, for one transaction > only, > not visible for other users. I keep a track (log) of those tables and delete > when I exit the program (drop table).
All of that is already supported by temporary tables -- each connection creates a **separate instance** of the GTT, so connections never see other data. 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 > is faster. "Blocked" why? Sean
