index on columns and on arrays

[Gluon]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Dear Friends,

 

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 :)

 

Thank you for your attention.

 

Best wishes to you.

 

sincerely, Gluon

[Ann W. Harrison]

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

firebird-support@...


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


Regards,


Ann



-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Firebird-test mailing list
Firebird-test@...
https://lists.sourceforge.net/lists/listinfo/firebird-test