sorry ... I hv just realized there is something that I haven't answered yet..

I perform the default rebuild indexes which has the feature ( Sort_temp = off ) and when i take a look on my temp db ( data file size is 792.56 MB and Volume usage = 0.25% ) and log file is 505MB ( volume usage = 0.16%)

meanwhile my database size is data file --> 5.36 GB ( volume usage = 1.78%)

log file 1 --> 5MB (volume usage = 0%)

log file 2 --> 15 GB ( volume usage = 9.37%)

I will rebuild around 23 indexes with each size around 0.3 GB

What do you think about it ?

thankss!!