Thanks for the suggestions Florien, I'll try out these suggestions and get back to you. I'm not sure whether t_zvndtransactions is temp already (I think it is) but I think...

Here is the UPDATE statement. It's in SAP Advanced Business Application Programming (ABAP) language, but you can get the gist. You can see that there is a COMMIT on every...

Statistics for INDEX 'ZVNDTRANSACTIONS~0'.

Updated Rows ...

So he does!

My apologies

You want details like density, fill level, depth, etc. on the index?

I can get some stats data if that's what you're after?

Invalid object name 'sys.dm_db_index_physical_stats'

Invalid object name 'sys.indexes'

tried running it in both the relevant DB and in the master DB....

TABLE STRUCTURE

Name: TABLE

FIELD1 varchar 3

FIELD2 tinyint 1

FIELD3 varchar 12

FIELD4 varchar 1

FIELD5 varchar 8

FIELD6 varchar 6

FIELD7 varchar...

Try

UPDATE STATISTICS (table_or_indexed_view_name) WITH FULLSCAN

and then check the stats on that table/index to see a full scan wasw done

or us the SAMPLE syntax (below) to set the sample rate.

Kind regards

Jamie

I'm pretty sure you can set the sample rate, I'll try and dig the syntax out