Is there other way to tune this query: select pricing.in_or_out_icon as icon, SUM(to_number(pricing.pricing_cash)) as sum_pricing_cash, SUM(to_number(pricing.present_cash)) as sum_present_cash, count(pricing.pricing_cash) as count from pricing_1 where type = “pricing” and price_identity = “5…

Hi Vsr1, Index used by above query is Create index ix1_pricing on pricing_1(price_identity, pricing.pricing_class_code,, pricing.function_code, pricing.issuer_settlement_code, pricing`.card_acceptor_country_code, DISTINCT array v in v.status_code for v in message_status End) where type=‘pricin…

You have multiple OR, NOT, EVERY predicates. I think best one be what i suggested. U can create one USE INDEX (ix1) and see how it performs. EVERY doesn’t work for ARRAY index. ANY AND EVERY can use ARRAY index. it may not that useful in your case. code != “000” is same all the time, you c…

ix2 index is not getting picked by query.

I tried 6.0.x it is picke up try with USE INDEX (ix2)

i tried reframing query and created covered partial index it worked. Thanks vsr1.Your suggestion are always helpful

How to tune the below query for optimal performance

SQL++

vsr1 April 9, 2020, 3:09pm 2

use following index.

CRATE INDEX ix1 ON pricing_1 (price_identity) WHERE type = “pricing”;

Topic		Replies	Views
Query optimization as its taking more time SQL++ index	5	635	July 20, 2022
Query time increases when logic changed SQL++ query , n1ql	1	724	August 29, 2019
Speed up array index and query SQL++ n1ql , index	4	1440	May 17, 2017
COUNT condition: INDEX Speed-up improvements SQL++ n1ql	34	3999	February 28, 2017
Slow N1QL search on using OR condition SQL++	16	1293	September 11, 2020

How to tune the below query for optimal performance

Related topics