I'd like to see a table by table option to change the way that data is put
down on pages. Right now, everyone stores rows of data on pages, which is a
nice compromise for update and select performance. The problem is that the
data can only be physically sorted one way and if you only need data from
one column you have to either pile through everything else in the table or
create a covering index.

I would like an option to store each column of a table in its own contiguous
page chain and have each column clustered.

The way you describe is the way Sybase IQ works. Check out the IQ
newsgroup.

doug

Jason Webster wrote:

> I'd like to see a table by table option to change the way that data is put
> down on pages. Right now, everyone stores rows of data on pages, which is a
> nice compromise for update and select performance. The problem is that the
> data can only be physically sorted one way and if you only need data from
> one column you have to either pile through everything else in the table or
> create a covering index.
>
> I would like an option to store each column of a table in its own contiguous
> page chain and have each column clustered.
>
>
>

I realize this. I just want them to add this to ase in a future release.

"Doug Wittich" <doug.wittich@yahoo.com> wrote in message
news:3D1E699C.2070706@yahoo.com...
> The way you describe is the way Sybase IQ works. Check out the IQ
> newsgroup.
>
> doug
>
> Jason Webster wrote:
>
> > I'd like to see a table by table option to change the way that data is
put
> > down on pages. Right now, everyone stores rows of data on pages, which
is a
> > nice compromise for update and select performance. The problem is that
the
> > data can only be physically sorted one way and if you only need data
from
> > one column you have to either pile through everything else in the table
or
> > create a covering index.
> >
> > I would like an option to store each column of a table in its own
contiguous
> > page chain and have each column clustered.
> >
> >
> >
>