Subject Is Order By , Where Use same Index
Author zaher
select * from "Accounts"
where "AccName" Like 'Z%'
order by "AccName"

"AccName" is indexed

so
order by use the index , and is Where also use the same index
the plan not mentioned that.

thanks
zaher dirkey