Hello
You can use index hint in select. If you have only one index, no need to use index hint. It will be automatically used by the system. But If you have more, you can specify index that you want to use.
Thanks
Chaminda
On 9/6/05, Cenk Ince <[EMAIL PROTECTED]> wrote:
Hi All;Assume that i have
Den 6. september 2005 17:29 skrev Cenk Ince:
> inventTrans table has some indexes on it. But when i create a select
> sentence for most records in table, i can't find an index that has
> fields itemid and dateFinancial. So i can't decide to use itemidX or
> OpenItemidx.
Always use the index where
Hi Cenk,
I would say yes. It should in most if not all cases speed up the query. Also, since it is just a HINT Axapta will not use it if there is a better of more efficient way of doing it.Cenk Ince <[EMAIL PROTECTED]> wrote:
Hi All;Assume that i have 4 fields on index index1 and i will run a
hi Cenk
the missing field value... where does it stand in the field order of the index?
i.e. if an index has fields 1,2,3,4
which value are you looking for?
Further, i think index hint has gone out of fashion with SP2 or SP3, I am not sure but give me some time to find out.
regards
h
4 matches
Mail list logo
