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
Select statement with more non indexed reads in version 2.5RC3 as in version 2.1.3 [CORE3103] #3481
Comments
Commented by: @dyemanov What is the plan in both v2.1 and v2.5? |
Modified by: @dyemanovsecurity: Developers [ 10012 ] => |
Commented by: Klaus-Dieter Pernak (festus01) Plan in Version 2.5RC3: Plan: ------ Leistungsinformation ------ Plan in Version 2.1.3 Plan: Adapted plan: ------ Leistungsinformation ------ |
Modified by: @dyemanovassignee: Dmitry Yemanov [ dimitr ] |
Modified by: @dyemanovstatus: Open [ 1 ] => In Progress [ 3 ] |
Modified by: @dyemanovstatus: In Progress [ 3 ] => Open [ 1 ] |
Commented by: @dyemanov It should be fixed in the following (tomorrow's) snapshot. Please test it and report back. |
Commented by: Klaus-Dieter Pernak (festus01) Sorry, it works better but not optimal. 1 indexed read and 0 non indexed read in table bstammdaten and Plan: Plan: ------ Leistungsinformation ------ Query Plan Query Time Memory Operations Enchanced Info: |
Commented by: @dyemanov I'm afraid a database is required then. Only these two tables are enough, just make sure the issue is reproducible in the reduced example. If you cannot show it to the public (and thus attach to the tracker), please send it (or the download link) to me at: firebird2 <at> yandex <dot> ru. |
Commented by: Klaus-Dieter Pernak (festus01) Now I am four weeks in holyday. After that I will continue work on this problem. |
Commented by: @dyemanov I'm marking this ticket as closed as I'm unable to reproduce the issue after the fix. It can be re-opened once a reproducible test case is provided. |
Modified by: @dyemanovFix Version: 2.1.4 [ 10361 ] => |
Modified by: @pcisarstatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovstatus: Closed [ 6 ] => Closed [ 6 ] QA Status: Done successfully Test Details: Reduced number of rows for checking: master table = 5000, detail = ~9000 |
Submitted by: Klaus-Dieter Pernak (festus01)
Is related to CORE2822
Relate to CORE3283
I have two tables "bauf" and "bstammdaten" with an foreign key in bauf to primary key in bstammdaten.
In table bstammdaten are 42000 and in bauf are 73000 records.
My select statement is:
select * from bauf
where id =
(select max(http://b.id) from bstammdaten a
left outer join bauf b on b.bstammdaten_id_maskenkey = http://a.id
where a.maskenkey='53')
The performance analysis in firebird 2.1 are 2 indexed reads in bauf and 1 indexed reads in bstammdaten.
If I make the same statement on the server with version 2.5 the result is:
73000 non indexed reads in bauf and
42000 non indexed reads in bstammdaten
The database will be every day restored from version 2.1 to 2.5 so that the two versions hold the same data.
festus01
Commits: 5f1d41a 3c11e2d
====== Test Details ======
Reduced number of rows for checking: master table = 5000, detail = ~9000
The text was updated successfully, but these errors were encountered: