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是排序好存储的。
cluster 分hashcluster和index cluster目的就是要把相同key值的数据放在一起存放。加快查询效率。
全表扫描要慢一些。
sorted hash cluster是排序好存储的。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11312660/viewspace-717643/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
