Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Optimize index scan when more than one index scanned and ANDed [CORE1069] #1490

Closed
firebird-automations opened this issue Dec 27, 2006 · 11 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

When two index scan's AND'ed pass first bitmap into second scan and set bit in second bitmap only if corresponding bit is set in first bitmap.
Then no need to perform AND operation on both bitmap's as second already ANDed with first one
This is reduced number operation on bitmaps and amount of memory needed for second bitmap

Commits: 2e343c7

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Ann Harrison (awharrison)

You could extend this to include OR's of indexed terms. Pass in the existing bit map and set bits
directly in it for hits in the second index.

@firebird-automations
Copy link
Collaborator Author

Commented by: @hvlad

Ann, please, take a look at EVL_bitmap, especially at nod_bit_in handler
Is it what you suggest ?
This logic was first introduced in Yaffil and then ported into FB2

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Reopened to update ticket information.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Closed [ 6 ] => Reopened [ 4 ]

resolution: Fixed [ 1 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Reopened [ 4 ] => Closed [ 6 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11440 ] => Firebird [ 14970 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Closed [ 6 ] => Closed [ 6 ]

QA Status: No test => Cannot be tested

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants