Hi Harry I look for all record and all fields of the records. I just wonder should i create index for situation (for ex fileds1,2,4 3 is missing) or can i use a index that has some fileds that i know the values. This is a generic question but to give an example, 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. They both have itemid., Hope i could explain problem. Thanks a lot.
________________________________
Kimden: Axapta-Knowledge-Village@yahoogroups.com bu kişinin yerine: Harry
(Harshawardhan Deshpande
Gönderilmiş: Sal 06.09.2005 18:12
Kime: Axapta-Knowledge-Village@yahoogroups.com
Konu: Re: [Axapta-Knowledge-Village] Index usage
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
harry
Cenk Ince <[EMAIL PROTECTED]> wrote:
Hi All;
Assume that i have 4 fields on index index1 and i will run a select
that i know 3 of the fields in index1. Shall i use index hint index1 in select
or not?
Thanks.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Sharing the knowledge on Axapta.
________________________________
YAHOO! GROUPS LINKS
* Visit your group "Axapta-Knowledge-Village
<http://groups.yahoo.com/group/Axapta-Knowledge-Village> " on the web.
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
________________________________
------------------------ Yahoo! Groups Sponsor --------------------~-->
Help Sudanese refugees rebuild their lives through GlobalGiving.
http://us.click.yahoo.com/hjNroD/EbOLAA/cosFAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
<<winmail.dat>>
