Dear masters, I want to know about indexing on insert query. I've read Database Concepts but I don't find what I want. This is the case.
I have a table that only have an index. We know that when an insert query is executed, Oracle will insert it on that table AND its index. My table just contain an index. What Oracle do to an index that newly inserted? When Oracle split a leaf that becoming full? How Oracle maintain that insert? I want for more detail explanation. http://en.wikipedia.org/wiki/B-tree#Insertion Oracle don't do an insert like this one (wikipedia). So, how Oracle do to an insert query? do to 1000 insert queries? And last question, how to see it? Thx for your expertise. Regards, Wiwin. Lebih bergaul dan terhubung dengan lebih baik. Tambah lebih banyak teman ke Yahoo! Messenger sekarang! http://id.messenger.yahoo.com/invite/ [Non-text portions of this message have been removed]
