p*1
2 楼
HP申请一个create partially sorted index的专利 (US 2008/0104102)。
"To provide an index for a table in a database system, the index is
partially sorted in an initial phase of building the index. Subsequently, in
response to accessing portions of the index to process a database query,
further sorting of the accessed portions of the index is performed."
it is using B-Tree, divid index into different internal nodes, will sort the nodes (but not the entire tree). where each node may overlap with each other.
"To provide an index for a table in a database system, the index is
partially sorted in an initial phase of building the index. Subsequently, in
response to accessing portions of the index to process a database query,
further sorting of the accessed portions of the index is performed."
it is using B-Tree, divid index into different internal nodes, will sort the nodes (but not the entire tree). where each node may overlap with each other.
v*r
4 楼
Oracle 的 B-Tree 是 fully sorted,好像没有这种 partilly sorted 的
implementation. 和 "fully sorted" 比较, "partilly sorted" 应该speed up
insert new record, but will slow down query using index.
implementation. 和 "fully sorted" 比较, "partilly sorted" 应该speed up
insert new record, but will slow down query using index.
s*s
5 楼
顶 五轮真弓
m*n
6 楼
I love this song
相关阅读
Access Security Problem哪里可以下载SQL学习资料Oracle 11g for Windows/Linux x86/Linux x86_64问个excel得问题 (转载)view management问题,谢谢!SAS 急问! 自动日期设置?求toad keyDB jobsDoes T-SQL have bit shift function?有熟悉php+mysql建web database的吗?part time job for computer science/engineering students.有比较好的支持中文的 Mysql的GUI么?MySQL全文搜索的问题请问:data modelingstupid stupid sql server-- what should I do?why this full-text search doenst work properly?sql server 被y l18.net攻击了 (转载)转行做数据库管理如何把hash of hash 存到数据库的table里?打听一下,有人了解 OSI Pi 吗? (转载)