Article View: cn.bbs.comp.database
Article #264Re: [help]����oracle����hash cluster������
From: Galaxy��VOLUNTEERS��Database
Date: Wed, 17 Jun 2009 09:02
Date: Wed, 17 Jun 2009 09:02
21 lines
2202 bytes
2202 bytes
��ɨ��hash��ʱ��ȡ���,ֻ�ڻ����ݵ�ʱ���ȡ,�����������˼? ��ͨ��cluster��ɨ��ʱ��һ��,�ڻ�õ�ʱ���ֶ�һ��,���... �� �� duduniao (duduniao) �Ĵ������ᵽ: �� : ��oracle�ٷ��ĵ��Ͽ�������һ�λ�: : "storing a table as a hash cluster with the primary key column as the cluster : key can allow an access based on a primary key value with a single disk I/O pr : ovided there is no overflow for that data block." : cluster��oracle��֯��ݱ��һ�ַ�ʽ,����,��������:department ,employee : ��������Ϳ��Ը������/����ϵclustered,����һ��,dep����ÿһ�ж���emp���о��� : ����depId�������д洢��һ��.(����join�������Ч,�ֲ�Υ����ʽԼ��) : ��hash cluster��������hash����ʵ�ֵ�һ��cluster��ʽ(Ҳ����ʹ��index on the clu : stering column). : ����������λ�����ô��Ҳû������.ΪʲôֻҪһ�����I/O? -- Welcome to Database Board ��ӭ������ݿ�� http://bbs.sjtu.edu.cn/bbsdoc?board=database [m[1;33m�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.28][m
Technical Details
Message-ID:
<4gRW4E$b0g@bbs.sjtu.edu.cn>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news2.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.byr.edu.cn!news.shec6.edu.cn!SJTUShow Full Headers
Complete Article Headers
X-Google-Thread: 4df683fd51,f63dfd6257d8649,start X-Google-Attributes: gid4df683fd51,public,usenet X-Google-NewGroupId: yes X-Google-Language: Chinese,GB Path: arc1-ca.pugleaf.net!g2news2.google.com!news1.google.com!news2.google.com!news.glorb.com!newsgate.cuhk.edu.hk!news.neu.edu.cn!news.byr.edu.cn!news.shec6.edu.cn!SJTU From: Dem.bbs@bbs.sjtu.edu.cn (Galaxy��VOLUNTEERS��Database) Newsgroups: cn.bbs.comp.database Subject: Re: [help]����oracle����hash cluster������ Date: 17 Jun 2009 09:02:23 GMT Organization: ��ˮ˼Դ Message-ID: <4gRW4E$b0g@bbs.sjtu.edu.cn> Mime-Version: 1.0 Content-Type: text/plain; charset="gb2312" Content-Transfer-Encoding: 8bit X-Filename: database/M.1245229262.A