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]