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.

fragmentation

2 posts in Windows NT Last posting was on 2000-04-19 22:13:32.0Z
Amro Posted on 2000-04-19 20:43:48.0Z
From: "Amro" <amr11@att.net>
Subject: fragmentation
Date: Wed, 19 Apr 2000 16:43:48 -0400
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <mU4MrDkq$GA.298@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: 1Cust95.tnt1.petersburg.va.da.uu.net 63.11.135.95
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2294
Article PK: 1089724

regarding devices in ASE, If rows in a table are inserted and then deleted,
that should cause data fragmentation in the database file or device in ASE.
Does the engine take care of that fragmentation. I noticed that in Adaptive
server Anywhere the db space which I understand is equivalent to device in
ase gets bigger and bigger, and the only way to defrag it and reduce the
size of the database, is to rebuild the database. Would some one shed the
light on this matter for me.
Amro


Jason Froebe Posted on 2000-04-19 22:13:32.0Z
Message-ID: <38FE2F8C.2EB5B1D7@sybase.com>
Date: Wed, 19 Apr 2000 17:13:32 -0500
From: Jason Froebe <jfroebe@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Amro <amr11@att.net>
Subject: Re: fragmentation
References: <mU4MrDkq$GA.298@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------01277685F4A19D521A3F8ACA"
Newsgroups: sybase.public.sqlserver.nt
Lines: 38
NNTP-Posting-Host: jfroebe-desktop.sybase.com 157.133.46.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2291
Article PK: 1089721


Amro wrote:

> regarding devices in ASE, If rows in a table are inserted and then deleted,
> that should cause data fragmentation in the database file or device in ASE.
> Does the engine take care of that fragmentation. I noticed that in Adaptive
> server Anywhere the db space which I understand is equivalent to device in
> ase gets bigger and bigger, and the only way to defrag it and reduce the
> size of the database, is to rebuild the database. Would some one shed the
> light on this matter for me.
> Amro

Hi Amro,

In ASE, the devices are static in size. They neither grow or shrink. As for
data fragmentation, rebuilding or temporarily applying a clustered index will
clear it up. On data only locking (DOL) tables (11.9.2.x and higher) you
would use reorg rebuild.

Jason


Download VCard jfroebe.vcf