Issue Details (XML | Word | Printable)

Key: CORE-3295
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Dmitry Yemanov
Votes: 0
Watchers: 0

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

Estimate the actual record compression ratio in the optimizer

Created: 28/Dec/10 11:53 AM   Updated: 28/Nov/17 06:48 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 2.1.4, 2.5.1, 3.0.3, 4.0 Beta 1

QA Status: No test

 Description  « Hide
Currently, when the table cardinality (number of records) gets estimated, all records are considered to be compressed twice in size (hardcoded compression ratio of 0.5). It would be better to have some estimation (even rough) of the actual compression ratio, because in practice it can differ much from the expected value. This becomes more important starting with versions 2.1.4 and 2.5.0 that have the join cost more depending on the proper cardinality estimations than in prior versions.

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