ITPUB个人空间 »
blue_or_white的个人空间
欢迎访问 blue_or_white 的个人空间
我的论坛主题
-
2008-09-28 21:00:54 / Oracle数据库管理
Is there any body know which mechanism Oracle uses to build an index.for example:a table A (a1, a2)has 1000 rows, I want to create an index idx_a1 on column a1.Then how does oracle create the index?Hypothesis 1:Oracle extracts all the data in column a1,and put it all into the sort area(memory or temp space or both of them), after completed sorting, writes the sorted data into the permanent tablespace to build the index.Hypothesis 2:Oracle divides the data of column a1 in
查看(140)
评论(5)
-
2008-07-05 22:39:29 / Oracle数据库管理
Is there any body can give me an answer?I am really confused about thiswelcome discusion!!!
查看(169)
评论(2)