Dear all,
I am using oracle Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - 64bit.
I came across the below documentation on Global temporary tables and tried to experiment the same.
- Indexes can be created on temporary tables. The content of the index and the scope of the index is the same as the database session.
I created a global temporary table in one session and Indexed a column in that table. I logged in another session and tried to explain plan a query on the GTT. I could find that the Index is being used in the query in the new session.
I understand from the above document is session specific, if so why is the query in the second session use the Index created in the first session. Kindly correct me if my understanding is wrong.