代码改变世界

随笔档案-2011年6月17日

B*Tree indexes

2011-06-17 14:29 by Tracy., 287 阅读, 收藏,
摘要: B*Tree, or what I call 'conventional', indexes are the most commonly used type of indexing structure in the database. They are similar in implementation to a binary search tree you might have learned... 阅读全文

Oracle:Materialized Views

2011-06-17 13:41 by Tracy., 1437 阅读, 收藏,
摘要: Types of Materialized Views The SELECT clause in the materialized view creation statement defines the data that the materialized view is to contain. There are only a few restrictions on what may be s... 阅读全文