ITPub博客

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

043-024

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-04 14:51:08 0 删除 编辑
24. You are designing an application for Certkiller .com and you have
been asked to design a database table to facilitate monthly bill gen
eration. The bill would include details of customer calls, listed in
chronological order. Which method would you follow to achieve this ob
jective without increasing the overhead of sorting the rows?
A. create a hash cluster to store the data
B. create an index cluster to store the data
C. create a partitioned table to store the data
D. create a sorted hash cluster to store the data
E. create a heap table with rowid to store the data
Answer: D
cluster 分hashcluster和index cluster目的就是要把相同key值的数据放在一起存放。加快查询效率。
全表扫描要慢一些。
sorted hash cluster是排序好存储的。

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

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

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203208