View Single Post
  #23 (permalink)  
Old 11-04-09, 04:32
mishaalsy mishaalsy is offline
Registered User
 
Join Date: Aug 2009
Posts: 262
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 .
Reply With Quote