Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Question concerning Index.
From: Christoph Weser (Christoph.WeserSeeTec.de)
Date: Wed Sep 20 2006 - 05:45:49 CDT
I'm using 18.104.22.168 on Windows and have a small question.
The table is:
create table s_event (
EID FIXED(38,0) NOT NULL,
ETID FIXED(38,0) NOT NULL,
SID FIXED(38,0) NOT NULL,
eventtime FIXED(38,0) NOT NULL,
data LONG BYTE
With folloing indices:
create index s_event_x1 on s_event(EID)
create index s_event_x2 on s_event(ETID)
create index s_event_x3 on s_event(SID)
create index s_event_x4 on s_event(CID)
create index s_event_x5 on s_event(eventtime)
Now I have populated the table with arount 13.000.000 rows.
EID and eventtime is for each row different, CID is often null, ETID has
just let's say around 10 different values, the same with SID.
But when I check the index sizes (select * from INDEXSTATISTICS WHERE
Description = 'Used pages') I see, that the Index s_event_x1 has around
56000 pages, all others around 36000 pages.
Is there an easy explanation whe x1 is that big?
Tahnx a lot!