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