Thanks for your kind response . Appreciate it!

Here is the data for 2 different databases ( the indexes get fragmented in only a few hours after rebuild ):

on Database DB1

Index IX_P (Non clustered index)

Index key column :

P1(datetime) , size : 8 , Identity : No

included column :

ReaderId (Int)

fragmentation : 92.31%

pages : 806

fill factor 65%

Usage stat :

USER_SEEKSUSER_SCANSUSER_LOOKUPSUSER_UPDATES

0 702 0 2826040

--------------------------------------------------------------------------------

on Database DB2

Index IX_A

Profile :

Index Key columns :

A1 (int)

A2 (TinyInt)

A3 (Bigint)

Fragmentation :81.44 %

Pagecount : 62593

Fill Factor : 70 %

Usage stat :

USER_SEEKSUSER_SCANSUSER_LOOKUPSUSER_UPDATES

49476 0 0 0

0 0 65176 4753949

8247327 0 2551491 2873118

0 1 0 2

-----------------------------------------------------------------------------

Index B (nonclustered)

Profile :

Index Key columns:

B1 (Bigint)

Included column :

X1 (tinyint)

X2 (varbinary(max)

X3 (bit)

X4 (int)

X5 (tinyint)

X6 (datetime)

X7 (bigint)

X8 (uniqueidentifier)

Fragmentation : 97.24%

Pagecount : 63379

Fill Factor : 70%

Usage stat :

USER_SEEKSUSER_SCANSUSER_LOOKUPSUSER_UPDATES

0 0 0 2873118

2 weeks ago :

USER_SEEKSUSER_SCANSUSER_LOOKUPSUSER_UPDATES

0 4 0 15808493

7580190 0 11550284

----------------------------------------------------------------------------

Index IX_C (nonclustered)

Profile :

Index key columns :

C1(bigint)

Fragmentation : 79.43%

Pagecount : 2163

Fillfactor : 70%

Usage stat:

USER_SEEKSUSER_SCANSUSER_LOOKUPSUSER_UPDATES

225313662780 563608

1 0 0 0

2845411199900 10

What do you think about it ?

Many thanks 🙂