Advantages and Disadvantages of TIME

Queries with time quantities are resolved more quickly than with other index types.

You can create and drop a TIME index.

Uses more disk space than HNG index.

Fast equality still requires LF or HG index.

You can use this index only if data in the column is TIME data type.