| Subject | Re: [ib-support] Is Order By , Where Use same Index |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2003-06-10T08:37:56Z |
At 02:04 10.06.2003 +0200, you wrote:
use "AccName" LIKE :Parameter. Hence, it could be a good idea changing to
"AccName" STARTING 'Z' ("AccName" STARTING :Parameter also uses an index).
Set
>select * from "Accounts"Yes, if you use "AccName" LIKE 'Z%' it will use an index, but not if you
>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.
use "AccName" LIKE :Parameter. Hence, it could be a good idea changing to
"AccName" STARTING 'Z' ("AccName" STARTING :Parameter also uses an index).
Set