prorm API Reference
    Preparing search index...

    Enumeration HintType

    Types of query hints supported

    Index
    FORCE_INDEX: "FORCE INDEX"

    Force use of a specific index

    USE_INDEX: "USE INDEX"

    Suggest using a specific index

    IGNORE_INDEX: "IGNORE INDEX"

    Ignore certain indexes

    JOIN_FIXED_ORDER: "JOIN_FIXED_ORDER"

    Force join order

    MERGE_HASH: "MERGE_HASH"

    Force hash join

    NO_MERGE: "NO_MERGE"

    Disable merge join

    NESTED_LOOP: "NESTED_LOOP"

    Use nested loop join

    MAX_EXECUTION_TIME: "MAX_EXECUTION_TIME"

    Maximum execution time in seconds

    SQL_BIG_RESULT: "SQL_BIG_RESULT"

    SQL_BIG_RESULT hint

    SQL_SMALL_RESULT: "SQL_SMALL_RESULT"

    SQL_SMALL_RESULT hint

    SEQ_SCAN: "SEQ_SCAN"

    PostgreSQL: Sequential scan

    NO_SEQ_SCAN: "NO_SEQ_SCAN"

    PostgreSQL: No sequential scan

    INDEX_SCAN: "INDEX_SCAN"

    PostgreSQL: Index scan

    NO_INDEX_SCAN: "NO_INDEX_SCAN"

    PostgreSQL: No index scan

    OPTIMIZE: "OPTIMIZE"

    SQLite: Optimize query

    QUERY_PLAN: "QUERY_PLAN"

    SQLite: Query plan

    SQL_BUFFER_RESULT: "SQL_BUFFER_RESULT"

    SQL_BUFFER_RESULT hint

    SQL_CACHE: "SQL_CACHE"

    SQL_CACHE hint (MySQL query cache)

    SQL_NO_CACHE: "SQL_NO_CACHE"

    SQL_NO_CACHE hint

    INDEX_MERGE: "INDEX_MERGE"

    Index merge hints

    SUBQUERY: "SUBQUERY"

    Subquery optimization hints