Module: ActiveRecord::ConnectionAdapters::SQLServer::Showplan

Included in:: ActiveRecord::ConnectionAdapters::SQLServerAdapter

Defined in:: lib/active_record/connection_adapters/sqlserver/showplan.rb,
lib/active_record/connection_adapters/sqlserver/showplan/printer_xml.rb,
lib/active_record/connection_adapters/sqlserver/showplan/printer_table.rb

Defined Under Namespace

Classes: PrinterTable, PrinterXml

Constant Summary collapse

OPTION_ALL =

'SHOWPLAN_ALL'

OPTION_TEXT =

'SHOWPLAN_TEXT'

OPTION_XML =

'SHOWPLAN_XML'

OPTIONS =

[OPTION_ALL, OPTION_TEXT, OPTION_XML]

Instance Method Summary collapse

#explain(arel, binds = []) ⇒ Object

Instance Method Details

#explain(arel, binds = []) ⇒ `Object`

# File 'lib/active_record/connection_adapters/sqlserver/showplan.rb', line 14

def explain(arel, binds = [])
  sql = to_sql(arel)
  result = with_showplan_on { sp_executesql(sql, 'EXPLAIN', binds) }
  printer = showplan_printer.new(result)
  printer.pp
end