table - sys_index_explain «Index Explanation»

Derivation Hierarchy

plan_execution «Plan Execution» Global
\| +—	plan_mysql «MySQL Explan Plan Step» Global
	\| +—	sys_index_explain «Index Explanation» Global

Status	Name	Label	Datatype	Length	Scope	Reference	Included By
	extra	Extra	string	254	Global		plan_mysql
	id	ID	string	40	Global		plan_mysql
	key	Key	string	40	Global		plan_mysql
	key_len	Key len	integer	40	Global		plan_mysql
	order	Order	integer	40	Global		plan_execution
	possible_keys	Possible keys	string	254	Global		plan_mysql
	ref	Ref	string	254	Global		plan_mysql
	rows	Rows	integer	40	Global		plan_mysql
	select_type	Select type	string	40	Global		plan_mysql
	stage	Stage	string	40	Global		sys_index_explain
	sys_class_name	Task Type	sys_class_name[choice]	80	Global		plan_execution
	sys_created_by	Created by	string	40	Global		plan_execution
	sys_created_on	Created	glide_date_time	40	Global		plan_execution
K	sys_id	Sys ID	GUID	32	Global		sys_index_explain
	sys_index_suggestion	Index Suggestion	reference	32	Global	sys_index_suggestion	sys_index_explain
	sys_mod_count	Updates	integer	40	Global		plan_execution
	sys_query_pattern	Sys query pattern	reference	32	Global	sys_query_pattern	plan_execution
	sys_updated_by	Updated by	string	40	Global		plan_execution
	sys_updated_on	Updated	glide_date_time	40	Global		plan_execution
	table	Table	table_name	80	Global		plan_mysql
	type	Type	string	40	Global		plan_mysql

Passive

Mandatory

Display Value

Key

Unique

Deleted

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out