Agreed. And Teaching1 and Teaching2. Give the tables names that describe their purpose.

I thought COBOL's data name length was 30 characters from the outset.

Just adding the ID column, it still does a table scan.

Adding the ID column AND a clustered index on the ID column, it then does a clustered index scan.

But since...

If you never query the tables by the ID column you are adding to use in the clustered index, how does it help queries?

If I have a heap table with...