|
Elements of a table index
When creating an SQL string for a dynamic query its very important to use and an index to avoid the full table scan and to get better query speed . In order to use an index , its very important to know the elements of an index of a table and its relevance for the sql on hand .
Normally one can scan ttadv420/1/2/3 tables to get the elements of a table index . Besides being complex , it also may differ from runtime dd at times . There is an easier route to get these element . table indices are combined colums of the table also . And one can use rdi.column.combined function to get the index elements as child columns. It may be possible that these child column too may be combined column (like 1st index of tdsls041 in Baan IV ) . In such a case , one needs to use rdi.column.combined function again on such combined fields.
Now rdi.column.combined is a well documented function in Baan along with other excellent rdi functions.
|