Thanks for the info Fabio,

Here is some background information:

1, There are exactly 2,929,716 records in pdmlog which WILL NOT grow anymore as this is now an archived table.

2, The maximum possible value for Reccount('temp') will be 1 ALWAYS. There will only be the ability to select 1 record.

3, On the pdmlog there is no index on the mainkey - STRANGE!!!

I hope this helps.

Many Thanks Fabio