EXPLAIN
From Recital Documentation Wiki
Revision as of 15:24, 12 October 2009 by Yvonnemilne (Talk | contribs)
Class
Performance and Optimization
Purpose
Syntax
See Also
Description
Display information about the optimization and result count of an SQL SELECT statement
Example
> EXPLAIN SELECT * FROM example sqlcnt=100 > EXPLAIN SELECT * FROM example WHERE start_date < date() Could not optimize WHERE condition sqlcnt=100 > EXPLAIN SELECT * FROM example WHERE account_no = '000' Optimized using index tag 'ACCOUNT_NO' sqlcnt=99
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
