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
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
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.
3 matches
Mail list logo