Subject | Re: [ib-support] Max number of indexes |
---|---|
Author | Ann W. Harrison |
Post date | 2002-11-23T21:04:40Z |
At 05:58 PM 11/21/2002 +0000, Chris Bland wrote:
of the page size and the length of the index name. Larger page sizes
with shorter names yield more indexes. Do create indexes after the
data is stored. For a read-only application, indexes with lots of
duplicates are not great problem - though they would be on read/write
data.
Regards,
Ann
www.ibphoenix.com
We have answers.
>The data is loaded in, and is read only after that. We can't predict withIn fact, the number of indexes that can be created is a function
>any certainty which columns will be drilled into, although we are performing
>some analysis on the columns which will allow us to determine which ones
>will benefit most from indexing. The number of columns is arbitrary - some
>users will have very wide files, e.g. 250+ attributes.
>
> >From what I have gleaned, sparse domains are questionable, with selectivity
>being the main deciding factor.
>
>Nevertheless, it would be useful not to have to worry about this maximum
>limit, just applying indexes as we deem appropriate.
>
>Is it there for a particular reason? Is it possible to make it go away...
of the page size and the length of the index name. Larger page sizes
with shorter names yield more indexes. Do create indexes after the
data is stored. For a read-only application, indexes with lots of
duplicates are not great problem - though they would be on read/write
data.
Regards,
Ann
www.ibphoenix.com
We have answers.