Question
Charter
US
Last activity: 9 Nov 2023 11:21 EST
Explain Generate Explain Plan
Hi, I am running the Generate Explain Plan for a query which gave me result below. By seeing the result, my plan is to make the query change. I was following the below Pega doc, it seems not a complete info. https://docs.pega.com/bundle/platform/page/platform/system-administration/database-sql-queries-improving.html Can anyone let me know is there other information available like how the Sort Key means and impact the query performance. Thanks for the help in advance.
Not full results - ============== Unique (cost=3.94..3.95 rows=1 width=10) -> Sort (cost=3.94..3.95 rows=1 width=10) Sort Key: "Acc".acct_id -> Nested Loop (cost=0.85..3.93 rows=1 width=10) Thanks, Neel