> I've been through and reread this thread a few times and I am quite
> confused about exactly what the situation is. You speak of deactivate
> and activate of the index and then having a different name, but you
> cant rename using ALTER INDEX (or is there something I dont know).

The name of the index is always I_CSSAPNR_A, but it there a two situations, in which the index seems to behave different and in
every situation I have given the index a different name, it's just for explaining.
Situation 1: Empty table, I called it index1
Situation 2: table with data and after deactivating and activating the index, I called it index2

> You also speak of fields being always null, so the index is not going
> to do you much good unless it is a compound index to improve
> selectivity.
>

That's right. Now the customers have no SAP-Nr, but in the future they will, so I have added the col, but at the moment the col is
always null.
For testing, I have filled the col CSSAPNR with data and then the phenomenon, I was talking about, disappears. That's the reason for
my last posting.
I hope, it's more clear now :-)


Guido