12.03.2015 15:13, liviuslivius wrote: > > is possible to extend this to show > > Range Scan (lower bound: 1/1, upper bound: 1/1) + (partial match: 1/2) > > like > Range Scan (partial match: 1/2, lower bound: 1/1, upper bound: 1/1) > > e.g. > compound index > > CREATE INDEX INDEX_NAME AAA ON XXX(A, B); > > SELECT > * > FROM > XXX X > WHERE > X.A>10 AND X.A<15 > > here we have partial index use(only A field) but also lower/upper bound
It should report: lower bound: 1/2, upper bound: 1/2. Here 1/2 means a partial match. 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
