A database stores sensor readings in a table where the sensor identifier is stored as a 36-character text field. A proposal changes the identifier to a compact numeric format (significantly fewer bytes per row). The table contains millions of rows. Which of the following is the primary mechanism by which this change reduces query energy?

Question

Accepted Answer

Smaller rows mean more rows fit on each disk page, so fewer pages must be read to process the same number of rows

Answer

The change eliminates the need for an index on the sensor identifier column

Answer

Numeric identifiers allow the database to use hash-based lookups instead of tree-based lookups

Answer

Numeric identifiers are compared faster by the processor than text identifiers

Crowdly

A database stores sensor readings in a table where the sensor identifier is stor...

Want instant access to all verified answers on moodle.polytechnic.bh?