a random one .
i am habitual of speaking while thinking .
welcome back . its great to see you again
correct me if i am wrong and i pray i am wrong. generating docid by newid() . gives random value .
so here in this index we have two sets of values . one starting from a to z . second starting from 1 to (max) numerics.
order by asc /desc achieves what ?
does this cluster index not forcing full index SCAN of all the rows on every execution ? . in my test case it is forcing this .
while every new insert or bulk insert is tending it to rebuild again ( ? ) is it. ? (rebuild is my oracle terminology... recreating itself . )
in my test case it is .