Explore BrainMass

Databases - Index Tables

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?


Solution Preview


The indexes do not help for query1.

The database engine will ...

Solution Summary

It shows how to index tables and run query.