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.

Will index rebuild reuse freed pages?

3 posts in General Discussion (old) Last posting was on 2008-08-19 06:23:20.0Z
Markus KARG Posted on 2008-08-18 10:04:13.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
Subject: Will index rebuild reuse freed pages?
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48a9491d$1@forums-1-dub>
Date: 18 Aug 2008 03:04:13 -0700
X-Trace: forums-1-dub 1219053853 10.22.241.152 (18 Aug 2008 03:04:13 -0700)
X-Original-Trace: 18 Aug 2008 03:04:13 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:129
Article PK: 866567

When I remove lots of rows out of a table and then run ALTER INDEX ...
REBUILD, this can lead to potentially empty pages (the sum of space that all
the deleted rows occupied). Will that pages later be reused, or are they
just "lost space"?

Thanks
Markus


Jason Hinsperger Posted on 2008-08-18 14:27:49.0Z
From: "Jason Hinsperger" <NO_jason_hinsperger_SPAM@hotmail.com>
Newsgroups: sybase.public.sqlanywhere
References: <48a9491d$1@forums-1-dub>
Subject: Re: Will index rebuild reuse freed pages?
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3350
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48a986e5$1@forums-1-dub>
Date: 18 Aug 2008 07:27:49 -0700
X-Trace: forums-1-dub 1219069669 10.22.241.152 (18 Aug 2008 07:27:49 -0700)
X-Original-Trace: 18 Aug 2008 07:27:49 -0700, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:131
Article PK: 866576

The pages will be re-used.

--
Jason Hinsperger
Product Manager
Sybase iAnywhere
http://iablog.sybase.com/hinsperg

SQL Anywhere Developer Community
http://www.ianywhere.com/developer

"Markus KARG" <karg@quipsy.de> wrote in message
news:48a9491d$1@forums-1-dub...
> When I remove lots of rows out of a table and then run ALTER INDEX ...
> REBUILD, this can lead to potentially empty pages (the sum of space that
> all the deleted rows occupied). Will that pages later be reused, or are
> they just "lost space"?
>
> Thanks
> Markus
>


Markus KARG Posted on 2008-08-19 06:23:20.0Z
From: "Markus KARG" <karg@quipsy.de>
Newsgroups: sybase.public.sqlanywhere
References: <48a9491d$1@forums-1-dub> <48a986e5$1@forums-1-dub>
Subject: Re: Will index rebuild reuse freed pages?
Lines: 33
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <48aa66d8@forums-1-dub>
Date: 18 Aug 2008 23:23:20 -0700
X-Trace: forums-1-dub 1219127000 10.22.241.152 (18 Aug 2008 23:23:20 -0700)
X-Original-Trace: 18 Aug 2008 23:23:20 -0700, vip152.sybase.com
X-Authenticated-User: panorama
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.sqlanywhere:132
Article PK: 866579

Great! :-)

Thanks for this answer!
Markus

"Jason Hinsperger" <NO_jason_hinsperger_SPAM@hotmail.com> schrieb im
Newsbeitrag news:48a986e5$1@forums-1-dub...

> The pages will be re-used.
>
> --
> Jason Hinsperger
> Product Manager
> Sybase iAnywhere
> http://iablog.sybase.com/hinsperg
>
> SQL Anywhere Developer Community
> http://www.ianywhere.com/developer
>
>
> "Markus KARG" <karg@quipsy.de> wrote in message
> news:48a9491d$1@forums-1-dub...
>> When I remove lots of rows out of a table and then run ALTER INDEX ...
>> REBUILD, this can lead to potentially empty pages (the sum of space that
>> all the deleted rows occupied). Will that pages later be reused, or are
>> they just "lost space"?
>>
>> Thanks
>> Markus
>>
>
>