Cluster Learning
Definition of ClustersA cluster is a group of one or more tables that share the same data blocks because they sharecommon columns and are often used together in join queries. Storing tables in clusters offersthe DBA a method to denormalize data. Clusters are transparent to the end user andprogrammer.Performance Benefits of Clusters• Disk I/O is reduced and access time improved for joins of clustered tables.• Each cluster key value is stored only once for all the rows of the same key
开博啦
今天终于收到OCP证书已经寄出的确认函。高兴之余,决定开博,:-),同时以blog督促自己这段时间自己的一些想法和学习。最近在学习Oracle的调优和MySql的一些文档,希望到时可以为自己增加一些砝码。继续努力。。。[@more@]