Hello,

Is it possible for Sybase to do the following or some sort of derivation in
ASE.

Logical Multi-Cluster For DSS
=====================================================

New Internal Table sysmulticluster For Each Index
That Links The page.offset To The Next page.offset
Based On The Index Keys.
=====================================================
OBJECT ID
INDEX ID
ROW PAGE
ROW OFFSET
PREVIOUS ROW PAGE
PREVIOUS ROW OFFSET
NEXT ROW PAGE
NEXT ROW OFFSET
PK(OBJECT ID, INDEX ID, ROW PAGE, ROW OFFSET)
=====================================================

1079, 5, 102934, 20, 0, 0, 102935, 32
1079, 5, 102935, 32, 102934, 20, 102935, 50

CREATE MULTICLUSTER INDEX
ON TABLE_A(COL_A, COL_B, COL_C, COL_D, COL_E, COL_F, COL_G, COL_H, COL_I,
COL_J, COL_K, COL_L, COL_M, COL_N)
WITH SAMPLES EVERY 1024 VALUES
go

The number of bytes for the SUM(INDEX KEYS) = 1300 Bytes. Tremendously
enormous!!! I would not want to create
an index such as this on a long table (fat is not really issue).

I just want index that uses samples of the table and the internal table
sysmulticluster
for the index to locate pages to start my searches.