Difference between revisions of "EXPLAIN"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
(No difference)
|
Revision as of 13:55, 29 May 2009
Class
Performance and Optimization
Purpose
Syntax
See Also
Description
Example
EXPLAIN SELECT * FROM example sqlcnt=100 EXPLAIN SELECT * FROM example WHERE start_date = date() Could not optimize WHERE condition sqlcnt=0 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
