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?© BrainMass Inc. brainmass.com March 4, 2021, 7:57 pm ad1c9bdddf
The indexes do not help for query1.
The database engine will ...
It shows how to index tables and run query.