Help Center/ GeminiDB/ GeminiDB Influx API/ FAQs/ Product Consulting/ How Do I Use GeminiDB Influx Hints?
Updated on 2023-11-21 GMT+08:00

How Do I Use GeminiDB Influx Hints?

GeminiDB Influx supports hints, improving query performance. Hints can be used only when you need to specify a value for each tag in a query statement. To use hints, add /*+ full_series */ before an SQL statement.

For example:

A common query statement is as follows:

 select value from cpu where server_id=1;

If a hint is used, the corresponding syntax is:

 select /*+ full_series */ value from cpu where server_id=1;