SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE gd_list_bank ref idx_useyn idx_useyn 1 const 1 100.00% Using index condition

Original SQL Statement

select 
  bank, 
  account, 
  name 
from 
  gd_list_bank 
where 
  useyn = 'y'

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  `pravs`.`gd_list_bank`.`bank` AS `bank`, 
  `pravs`.`gd_list_bank`.`account` AS `account`, 
  `pravs`.`gd_list_bank`.`name` AS `name` 
from 
  `pravs`.`gd_list_bank` 
where 
  (
    `pravs`.`gd_list_bank`.`useyn` = 'y'
  )