Hello all,

Could someone please explain something to me?
If I have a local view on to a single table that just selects some output fields and filters on an ID value being equal to a variable. If my table is indexed on the ID why does my optimisation come back saying that it is using the index but that it is only partially optimised?

SELECT *;
 FROM ash!agent;
 WHERE Agent.iid = ?ThisForm.ID


Using index tag Id to rushmore optimize table agent
Rushmore optimization level for table agent: partial

And does this matter?

Many thanks
Caroline