Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

What is global clustered index?

4 posts in General Discussion Last posting was on 2009-12-23 05:52:02.0Z
Yaniv C. Posted on 2009-12-22 08:39:48.0Z
Sender: dd5.4b3081b8.1804289383@sybase.com
From: Yaniv C.
Newsgroups: sybase.public.ase.general
Subject: What is global clustered index?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b3085d4.e16.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Dec 2009 00:39:48 -0800
X-Trace: forums-1-dub 1261471188 10.22.241.41 (22 Dec 2009 00:39:48 -0800)
X-Original-Trace: 22 Dec 2009 00:39:48 -0800, 10.22.241.41
Lines: 22
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28799
Article PK: 78042

Hi
I am using ASE 15.0.2ESD#2 and having 500M records in a
roundrobin partition table.
The roundrobin partition is for many small transactions
inserts. I am making many concurrent inserts which,for my
opion, roundrobin is best for it.(each record to different
partition)

Anywhy, the unique index is global noneclustered and I am
checking the impact of changing it to global clustered...

My question is for global clustered index on roundrobin
partition. How does it work? How the index can be clustered
when it is partitioned?
I can find many diagrams,explainations and pictures for
(1)local clustered, (2)global noneclustered, (3)local
noneclustered but not a word on global clustered...

Someone can provide information on global clustered index?

Thanks,
Yaniv


J Posted on 2009-12-22 16:11:15.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.general
Subject: Re: What is global clustered index?
Reply-To: J@bogusemailAddress.com
Message-ID: <4b30ef36.87902507@forums.sybase.com>
References: <4b3085d4.e16.1681692777@sybase.com>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 22 Dec 2009 08:11:15 -0800
X-Trace: forums-1-dub 1261498275 10.22.241.152 (22 Dec 2009 08:11:15 -0800)
X-Original-Trace: 22 Dec 2009 08:11:15 -0800, vip152.sybase.com
Lines: 32
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28800
Article PK: 78041

On 22 Dec 2009 00:39:48 -0800, Yaniv C. wrote:

google this search key: global clustered index site:sybase.com
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug444.htm

Look at the explanation there and ask any remaining question.

Jay

>Hi
>I am using ASE 15.0.2ESD#2 and having 500M records in a
>roundrobin partition table.
>The roundrobin partition is for many small transactions
>inserts. I am making many concurrent inserts which,for my
>opion, roundrobin is best for it.(each record to different
>partition)
>
>Anywhy, the unique index is global noneclustered and I am
>checking the impact of changing it to global clustered...
>
>My question is for global clustered index on roundrobin
>partition. How does it work? How the index can be clustered
>when it is partitioned?
>I can find many diagrams,explainations and pictures for
>(1)local clustered, (2)global noneclustered, (3)local
>noneclustered but not a word on global clustered...
>
>Someone can provide information on global clustered index?
>
>Thanks,
>Yaniv


Yaniv C. Posted on 2009-12-22 20:49:56.0Z
Sender: 1e16.4b312edf.1804289383@sybase.com
From: Yaniv C.
Newsgroups: sybase.public.ase.general
Subject: Re: What is global clustered index?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b3130f4.1e6c.1681692777@sybase.com>
References: <4b30ef36.87902507@forums.sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 22 Dec 2009 12:49:56 -0800
X-Trace: forums-1-dub 1261514996 10.22.241.41 (22 Dec 2009 12:49:56 -0800)
X-Original-Trace: 22 Dec 2009 12:49:56 -0800, 10.22.241.41
Lines: 51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28801
Article PK: 78043

Hi Jay

Thanks for the links. The explaination in the link is not
satisfying...
on DOL roundrobin table how does the index can be global
clustered?
Beside drawing a big box and mark it as "index" I can not
really understand how the index can maintance data pages
ordered when the table is partitioned without any order of
keys.
Is there any in depth explaination? (more than Box draw)

Thanks,
Yaniv

> On 22 Dec 2009 00:39:48 -0800, Yaniv C. wrote:
>
> google this search key: global clustered index
> site:sybase.com
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.help.ase_15.0.sqlug/html/sqlug/sqlug444.htm
>
> Look at the explanation there and ask any remaining
> question.
>
> Jay
>
> >Hi
> >I am using ASE 15.0.2ESD#2 and having 500M records in a
> >roundrobin partition table.
> >The roundrobin partition is for many small transactions
> >inserts. I am making many concurrent inserts which,for my
> >opion, roundrobin is best for it.(each record to
> different >partition)
> >
> >Anywhy, the unique index is global noneclustered and I am
> >checking the impact of changing it to global clustered...
> >
> >My question is for global clustered index on roundrobin
> >partition. How does it work? How the index can be
> clustered >when it is partitioned?
> >I can find many diagrams,explainations and pictures for
> >(1)local clustered, (2)global noneclustered, (3)local
> >noneclustered but not a word on global clustered...
> >
> >Someone can provide information on global clustered
> index? >
> >Thanks,
> >Yaniv
>


Michael Peppler [Team Sybase] Posted on 2009-12-23 05:52:02.0Z
From: "Michael Peppler [Team Sybase]" <mpeppler@peppler.org>
Organization: Peppler Consulting SARL
Subject: Re: What is global clustered index?
User-Agent: Pan/0.14.2 (This is not a psychotic episode. It's a cleansing moment of clarity.)
Message-ID: <pan.2009.12.23.05.52.02.313197@peppler.org>
Newsgroups: sybase.public.ase.general
References: <4b30ef36.87902507@forums.sybase.com> <4b3130f4.1e6c.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 22 Dec 2009 21:52:02 -0800
X-Trace: forums-1-dub 1261547522 10.22.241.152 (22 Dec 2009 21:52:02 -0800)
X-Original-Trace: 22 Dec 2009 21:52:02 -0800, vip152.sybase.com
Lines: 23
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28803
Article PK: 78048


On Tue, 22 Dec 2009 12:49:56 -0800, wrote:

> Hi Jay
>
> Thanks for the links. The explaination in the link is not
> satisfying...
> on DOL roundrobin table how does the index can be global
> clustered?
> Beside drawing a big box and mark it as "index" I can not
> really understand how the index can maintance data pages
> ordered when the table is partitioned without any order of
> keys.
> Is there any in depth explaination? (more than Box draw)
>

A clustered index on a DOL table will in any case NOT maintain the data
pages in index order. What it will do is attempt to place new rows "close"
to existing rows with similar index values on the data page, and it will
also make sure that data pages are on the same segment as the clustered
index.

Michael