> I think that you can understand better. I have tested this with
> TIBOTable, I don't like this component but it setups the refinament
> automatically but in the sql monitor I see like it doesn't user the
> ID index.

What is the primary key of the table? AFAIK TIBOTable will try to
automatically determine the key but I am not sure of the details
because I dont use this component myself. From what you have said so
far it seems the primary key should be on ID. Just having an index on
ID is not quite the same, because IBO will not automatically detect it
when defining keylinks.

Using TIBOQuery and the settings provided in my prior email allow you
to be more specific (forcing the dataset to use ID as the keylink
regardless of whether it is defined as the primary key or not). To
get refinement enabled in TIBOQuery setup the OrderingLinks as:
PARENT_ID=ITEM=1;POS=0

Note: I am not certain this will help but its worth trying.

--
Geoff Worboys
Telesis Computing