Re: [Axapta-Knowledge-Village] when to use Index and index hint

2010-08-19 Thread thomas 'znal' ramdhan
ill...@yahoogroups.com] *On Behalf Of *thomas 'znal' > ramdhan > *Sent:* 19 August 2010 03:12 > *To:* Axapta-Knowledge-Village@yahoogroups.com > *Subject:* Re: [Axapta-Knowledge-Village] when to use Index and index hint > > > > > > Hi Malcolm, > > From a

RE: [Axapta-Knowledge-Village] when to use Index and index hint

2010-08-19 Thread Malcolm Burtt
owledge-vill...@yahoogroups.com] On Behalf Of thomas 'znal' ramdhan Sent: 19 August 2010 03:12 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] when to use Index and index hint Hi Malcolm, >From above question, I'd like to ask another quest

Re: [Axapta-Knowledge-Village] when to use Index and index hint

2010-08-18 Thread thomas 'znal' ramdhan
Hi Malcolm, >From above question, I'd like to ask another question which related to indexhint. Let's say I need to query to tableA which field criteria is field1. select * from tableA where tableA.field1 = _field1 indexs for table A are below 1. NumIdx field1 field2 field3 2. It

RE: [Axapta-Knowledge-Village] when to use Index and index hint

2010-08-18 Thread Malcolm Burtt
Burtt Touchstone Group People - Partnership - Solutions From: Axapta-Knowledge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of pranam mukher Sent: 18 August 2010 12:17 To: axa knwoldge; dev ax Subject: [Axapta-Knowledge-Village] when to use Index and index

[Axapta-Knowledge-Village] when to use Index and index hint

2010-08-18 Thread pranam mukher
hi I am aware of the fact that using index in select statement will include an order by clause in ur SQL query. i want to know, exactly when shud i use index and when to opt for index hint, in my Queries. Thanks Pradeep.SI