TIME indexes have advantages and disadvantages.
Advantages |
Disadvantages |
---|---|
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. |