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

[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