Index Scans: Key-First

QUERY:

select count(e)from mytable

where a=1

and b=1

and d="Y"

Estimated Cost: 4

Estimated # of Rows Returned: 1

1) informix.mytable: INDEX PATH

Filters: informix.mytable.d = 'Y'

(1) Index Keys: a b c d (Key-First) (Serial, fragments: ALL)

Lower Index Filter: (informix.mytable.a = 1 AND informix.mytable.b = 1 )

Previous slide

Next slide

Back to first slide

View graphic version