Re: [Firebird-test] index on columns and on arrays

[Ann W. H. <aha...@ib...>]

Gluon wrote:

> Can we create an index on 128 integer columns (fields) ?
> 
> I need this index very much, and in FB2.0 beta 1, it is impossible because an index can contain no more than 16 columns.
> 
> Since we enhanced the indexing, index size limitation of 252 bytes is gone (Thanks to A. Brinkman and other developers), why an index cannot be created on an array or more than 16 columns? 
> 
> I learned very little on DB indexing, and need your help indeed :) 
> 

You'll get better answers on the firebird-support list

fir...@ya...


But when you send mail there, do explain why you need
an index on 128 columns at once rather than several indexes.


Regards,


Ann