If you were to index the tables 1000_ROWS and 2000_ROWS and then run query1, would the table 20CHAR_TABLE be created faster than if the tables were not indexed (try it out)? Why?
The indexes do not help for query1.
The database engine will ...
It shows how to index tables and run query.