> 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