better not to use index hint. Then you will be disallowing the database query
optimizer to take decision as to which one of the indices to be used for better
performance. Right from 5.0 its being removed.
--- On Wed, 18/8/10, pranam mukher <pranam_shub...@yahoo.co.in> wrote:
From: pranam mukher <pranam_shub...@yahoo.co.in>
Subject: [development-axapta] when to use Index and index hint
To: "axa knwoldge" <axapta-knowledge-vill...@yahoogroups.com>, "dev ax"
<development-axapta@yahoogroups.com>
Date: Wednesday, 18 August, 2010, 4:17 AM
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
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
