ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-102

043-102

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-08 09:02:08 0 删除 编辑
102. While designing the database for one of your online transaction
processing (OLTP) applications, you want to achieve the following:
a) high availability of data
b) faster primary key access to the table data
c) compact storage for the table
Which type of tables would you use to achieve these objectives?
A. heap tables
B. object tables
C. partitioned tables
D. index-organized tables (IOTs)
Answer: D
Index-organized tables provide faster access to table rows by the
primary key or any key that is a valid prefix of the primary key.
Because rows are stored in primary key order, a significant amount of
additional storage space savings can be obtained through the use of key
compression.
Use of primary-key based logical rowids, as opposed to physical rowids,
in secondary indexes on index-organized tables allows high availability.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718015/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 043-101
下一篇: 043-103
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    204365