Assume I have 2 tables - TABLE-1 & TABLE-2 and each of the table has 1 million rows with 10 columns and index on col1..

Now I build a internal table on this 2 tables ( 1 + 1 = 2 million) rows,

```
select * from 
(select col1, col2,....col10 from table-1
union all
select col1, col2,....col10 from table-2) x

```

Questions,

```
how will the internal table will be treated in Oracle since its a internal table..
1. Will the internal table will be treated as a table with index on col1?
2. Will this be captured in the Explain plan?

```