Does that mean , I cannot use that index too if I ...
# generals
Sukesh Boggavarapu
03/28/2022, 3:58 PMDoes that mean , I cannot use that index too if I want upsert to be configured for a table?
m
Mayank
03/28/2022, 5:41 PM
Yes, StarTree Index is not supported with upsert. But note that startree index helps in case of really low selectivity queries (millions of rows selected by the query. And you can still get great perf from other indexes.
Mayank
03/28/2022, 5:42 PM
You can use sorted index with upsert.
s
Sukesh Boggavarapu
03/29/2022, 11:58 AMGotcha. Thanks.