12.03.2015 16:13, liviuslivius wrote:
>
> i only have question with this:
>
> CREATE TABLE XXX
> (
> A INTEGER,
> B INTEGER,
> C INTEGER,
> D INTEGER,
> E INTEGER
> );
>
> CREATE INDEX IXA_XXX__ALL ON XXX(A, B, C, D, E);
>
>
> SELECT
>       *
> FROM
>       XXX X
> WHERE
>       X.A=5
>      AND X.B=6
>      AND X.C>6
> Range Scan (lower bound: 3/5, upper bound: 2/5)

There's an implicit upper bound on {A, B}, the index scan begins past 
{5, 6, 6, whatever} and continues as long as the key keep starting with 
{5, 6}, then ends.


Dmitry


------------------------------------------------------------------------------
Dive into the World of Parallel Programming The Go Parallel Website, sponsored
by Intel and developed in partnership with Slashdot Media, is your hub for all
things parallel software development, from weekly thought leadership blogs to
news, videos, case studies, tutorials and more. Take a look and join the 
conversation now. http://goparallel.sourceforge.net/
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to