SQL Analyzer


Explain Extended

ID Select Type Table Access Type Possible Keys Used Key Key Length Ref Rows Examined Filtered Extra
1 SIMPLE gd_code ref idx_groupcd idx_groupcd 32 const 2 100.00% Using index condition; Using where; Using filesort

Original SQL Statement

select 
  itemcd, 
  itemnm 
from 
  gd_code 
where 
  groupcd != '' 
  and groupcd = 'cooperation' 
order by 
  sort

Converted SQL Statement (MySQL Optimizer)

/* select#1 */
select 
  `pravs`.`gd_code`.`itemcd` AS `itemcd`, 
  `pravs`.`gd_code`.`itemnm` AS `itemnm` 
from 
  `pravs`.`gd_code` 
where 
  (
    `pravs`.`gd_code`.`groupcd` = 'cooperation'
  ) 
order by 
  `pravs`.`gd_code`.`sort`