What SELECT * costs in real code

• A

  It is slower to parse because the full column list has to be expanded first

• B

  It transfers columns nobody uses and can prevent an index-only read

• C

  It breaks if columns are reordered in the table

• D

  It prevents the database from using any index at all