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:
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.
Varden Morris
Senior Developer
WellPoint Systems Inc.
Suite 2000, 500 - 4th Ave SW
Calgary, Alberta, Canada
T2P 2V6
(403) 444-5848 direct
(403) 444-3900 main
www.wellpoint.ca
[EMAIL PROTECTED]
Click here to donate to the Hurricane Katrina relief effort.
Sharing the knowledge on Axapta.
YAHOO! GROUPS LINKS
- Visit your group "Axapta-Knowledge-Village" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
