>From Shahrzad Shirazi <[email protected]>: Shahrzad Shirazi has posted comments on this change. ( https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17729 )
Change subject: [ASTERIXDB-3637][COMP] Simplify Index-only plan ...................................................................... Patch Set 54: (3 comments) File asterixdb/asterix-app/src/test/resources/optimizerts/results/btree-index-selection/btree-index-composite-key-04.plan: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17729/comment/e82980ef_81c9c824 PS47, Line 16: -- HASH_PARTITION_EXCHANGE [$$22] |PARTITIONED| > I wasn't expecting a hash-join. The plan seems a bit odd. […] Changed, now we do not have this and the order-hash-order is gone as well for order- distinct . File asterixdb/asterix-app/src/test/resources/runtimets/results_cbo/index-only-testcases/heterogeneous-index-only-compund-keys/heterogeneous-index-only-compund-keys.5.plan: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17729/comment/106493c6_1eafc9bf PS47, Line 11: data-scan []<-[$$18, $$c] <- test.Customers > Can you file an issue for CBO? Index-only should be cheaper than data-scan. Done File asterixdb/asterix-app/src/test/resources/runtimets/results_column/index-only-testcases/simple-index-only/simple-index-only.4.plan: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17729/comment/85e4ba10_44c27eef PS47, Line 15: data-scan []<-[$$21, $$Orders] <- test.Orders project > Just checking, is this supposed to be a data-scan or index-only? Fixed now and it is using the index-only query plan. Previously a typo in the query was causing the issue. -- To view, visit https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17729 To unsubscribe, or for help writing mail filters, visit https://asterix-gerrit.ics.uci.edu/settings Gerrit-Project: asterixdb Gerrit-Branch: master Gerrit-Change-Id: I516dc90b8da3a7086dc80b67946a5d4f6dde0972 Gerrit-Change-Number: 17729 Gerrit-PatchSet: 54 Gerrit-Owner: Shahrzad Shirazi <[email protected]> Gerrit-Reviewer: Ali Alsuliman <[email protected]> Gerrit-Reviewer: Anon. E. Moose #1000171 Gerrit-Reviewer: Jenkins <[email protected]> Gerrit-Comment-Date: Thu, 04 Sep 2025 14:27:56 +0000 Gerrit-HasComments: Yes Gerrit-Has-Labels: No Comment-In-Reply-To: Ali Alsuliman <[email protected]> Gerrit-MessageType: comment
