Re: Having too many indexes on a table

Posted in 1998

SailF3 — 05 May 1998 00:46:26 GMT — source: Informix-list mailing list archive (1991-1998)

> I have a table with 10 columns, and row size is 261 and index size >> is 117. >> I need indexes on these columns. >> >> 1. userid, startdate >> 2. userid, wcc >> 3. wcc, startdate >> 4. sesssionid ( I do not do query on this, But it is primary key for >> making row unique) >> >> I need to know about these problems Without a sqexplain.out, or an example of your application(s), I am just shooting in the dark. Never stopped me before. Iwould imagine you have some queries that are interested in the startdate. try making index #1( startdate,userid) . You still have a userid index at the head of #2 , and you now have an index on that date. email me and let me know. Sean Bradley sailf3@aol.com