11.04.2016 14:40, Dimitry Sibiryakov wrote: > > While bug with orphan index nodes is living in the engine - index only scan is > impossible completely.
Pure index-only scan - maybe. It's impossible without transaction numbers in indices too. But there may be other alternatives to consider. > Transformation numeric->double can loose data. Using integers as a key will > disable > altering of numeric columns. May be it worth considering. Perhaps we could live with a requirement to rebuild an index for integer<->floating modifications. But I'd like to preserve "opaque" conversions between different NUMERICs. > Transformation string->key by ICU does loose data, no way back. True for case- and accent-insensitive collations, but probably not always true for simple cases. Anyway, I care less about strings than about integers and dates/times. Dmitry ------------------------------------------------------------------------------ Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/ gampad/clk?id=1444514301&iu=/ca-pub-7940484522588532 Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
