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>>