• R
    Support Optimizer Hints · 97347d8c
    Ryuta Kamizono 提交于
    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
query_methods.rb 42.2 KB