db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <de...@segel.com>
Subject RE: clustered index
Date Wed, 01 Mar 2006 13:22:36 GMT

That is what Informix's clustered index does....
(Meaning it’s the primary key index and the data is organized on disk to
match the index.)

Online has been deprecated (sun set, unsupported, ...) many moons ago.
(Informix 5.x is Online. IDS (Dynamic Server) is 7.x, 9.x and now 10.x.
Of course there was C-ISAM, SE, and Turbo....
(Yeah, I'm that old ... ;-)

BTW, I really can't imagine the usefulness of an index that isn't up to

> -----Original Message-----
> From: Øystein Grøvlen [mailto:Oystein.Grovlen@Sun.COM]
> Sent: Wednesday, March 01, 2006 1:18 AM
> To: Derby Discussion
> Subject: Re: clustered index
> tom wrote:
> > I mean an index that kept up to date on disk permanently. This is the
> definition
> > that I know from the time I was using Informix Online. The syntax was
> 'create
> > clustered index ...'. I don't mean to put it on the primary key as SQL-
> Server
> > does, but having the possibility to create one would be helpful.
> I would think any index would be kept up to date on disk permanently.
> --
> Øystein

View raw message