Issue Details (XML | Word | Printable)

Key: CORE-1846
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 3
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Allow index walk (ORDER plan) when there's a composite index {A, B} and the query looks like WHERE A = ? ORDER BY B

Created: 18/Apr/08 01:40 AM   Updated: 30/Oct/15 05:47 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 3.0 Alpha 2

Issue Links:
Relate
 

QA Status: Done successfully


 Description  « Hide
select *
from RDB$COLLATIONS
where RDB$COLLATION_ID = 0
order by RDB$CHARACTER_SET_ID

Current plan is:
PLAN SORT ((RDB$COLLATIONS INDEX (RDB$INDEX_26)))

It should better be:
PLAN (RDB$COLLATIONS ORDER RDB$INDEX_26)


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no comments yet on this issue.