On Mon, Apr 11, 2016 at 6:15 PM, Dmitry Yemanov <firebi...@yandex.ru> wrote:
> 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.
>
>
+1
--
Regards,
Atri
*l'apprenant*
------------------------------------------------------------------------------
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
