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

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

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

Hi For most queries, the answer is to use neither. “Index Hint” overrides the SQL Query optimiser and forces the use of the specified index – which is ok if you’re sure that the optimiser is picking a bad query plan and that using “index hint” allows your query to run faster but most of the

[Axapta-Knowledge-Village] InventDim in a Relation definition?

How can I specify a component of InventDim in a relationship? I want to relate a table that has just ItemId and InventSerialId to InventSum, which has ItemId, and InventDim. - Please help! I don't see anyway to create a relationship like this on the table-definitions.

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

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.