Skip to content
  • Ryuta Kamizono's avatar
    97347d8c
    Support Optimizer Hints · 97347d8c
    Ryuta Kamizono authored
    We as Arm Treasure Data are using Optimizer Hints with a monkey patch
    (https://gist.github.com/kamipo/4c8539f0ce4acf85075cf5a6b0d9712e),
    especially in order to use `MAX_EXECUTION_TIME` (refer #31129).
    
    Example:
    
    ```ruby
    class Job < ApplicationRecord
      default_scope { optimizer_hints("MAX_EXECUTION_TIME(50000) NO_INDEX_MERGE(jobs)") }
    end
    ```
    
    Optimizer Hints is supported not only for MySQL but also for most
    databases (PostgreSQL on RDS, Oracle, SQL Server, etc), it is really
    helpful to turn heavy queries for large scale applications.
    97347d8c
    Support Optimizer Hints
    Ryuta Kamizono authored
    We as Arm Treasure Data are using Optimizer Hints with a monkey patch
    (https://gist.github.com/kamipo/4c8539f0ce4acf85075cf5a6b0d9712e),
    especially in order to use `MAX_EXECUTION_TIME` (refer #31129).
    
    Example:
    
    ```ruby
    class Job < ApplicationRecord
      default_scope { optimizer_hints("MAX_EXECUTION_TIME(50000) NO_INDEX_MERGE(jobs)") }
    end
    ```
    
    Optimizer Hints is supported not only for MySQL but also for most
    databases (PostgreSQL on RDS, Oracle, SQL Server, etc), it is really
    helpful to turn heavy queries for large scale applications.
Loading