Hi, simple table CREATE TABLE XXX( A INTEGER , B INTEGER , CONSTRAINT UK_XXX__A__B UNIQUE(A, B) ) commit; SELECT * FROM dbo.XXX X WHERE X.A BETWEEN 2 AND 30 AND X.B BETWEEN 5 AND 60 Select Expression -> Filter -> Table "XXX" as "X" Access By ID -> Bitmap -> Index "UK_XXX__A__B" Range Scan (lower bound: 1/2, upper bound: 1/2) As you can see only A key is used but B key should be also used. I am missing something? Is this issue in Firebird3 or this is not existing feature? AFAIK in MSSQL this work ok regards, Karol Bieniaszewski
[firebird-support] Composite index - issue or not existing feature?
liviuslivius [email protected] [firebird-support] Mon, 14 Mar 2016 00:33:07 -0700
- [firebird-s... liviuslivius [email protected] [firebird-support]
- [fireb... Dmitry Yemanov [email protected] [firebird-support]
- Re: [f... setysvar [email protected] [firebird-support]
- Re... Ann Harrison [email protected] [firebird-support]
