| Subject | Re: [firebird-support] Firebird 3.0.4 unicode_ci_ai index problems |
|---|---|
| Author | Luis Forra |
| Post date | 2018-10-15T21:57:35Z |
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 sd@... [firebird-support] <firebird-support@yahoogroups.com> escreveu:
15.10.2018 15:00, Luis Forra luis.forra@... [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
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)
<*> To change settings via email:
firebird-support-digest@yahoogroups.com
firebird-support-fullfeatured@yahoogroups.com
<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<*> Your use of Yahoo Groups is subject to:
https://info.yahoo.com/legal/us/yahoo/utos/terms/