You are telling me that in my example the index unicode_ci_ai of two varchar(10) don't fit in a 8K page but with Unicode fit ? What page size do you recommend ?
A segunda, 15/10/2018, 20:14, Dimitry Sibiryakov s...@ibphoenix.com [firebird-support] <firebird-support@yahoogroups.com> escreveu: > 15.10.2018 15:00, Luis Forra luis.fo...@gmail.com [firebird-support] > wrote: > > What I'm doing wrong ? > > CI AI indexes are much bigger because of ICU implementation of index > key derivation. > You must increase page size of your database to return index depth to norm. > > > -- > WBR, SD. > > > ------------------------------------ > > ------------------------------------ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > > Visit http://www.firebirdsql.org and click the Documentation item > on the main (top) menu. Try FAQ and other links from the left-side menu > there. > > Also search the knowledgebases at > http://www.ibphoenix.com/resources/documents/ > > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ > ------------------------------------ > > Yahoo Groups Links > > > >