Is there a index that helps performance for LASTWI...
# generalj
Jasper Potts
08/01/2022, 5:19 PMIs there a index that helps performance for LASTWITHTIME() ?
k
Kishore G
08/01/2022, 5:25 PM
startree index could be a potential solution
Kishore G
08/01/2022, 5:25 PM
you can also use upsert
j
Jasper Potts
08/01/2022, 5:32 PMI was hoping to avoid upsert because of the other constraints if possible. Thanks 🙂
k
Kishore G
08/01/2022, 7:47 PM
yeah, startree index should work.. do we have the ability to support any UDF in startree index @Jackie?
j
Jackie
08/01/2022, 7:53 PMLAST_WITH_TIME is actually an aggregation instead of regular UDF (transform).
Jackie
08/01/2022, 7:54 PMI think it can work with star-tree, but we need to solve the challenge of accessing multiple columns for the star-tree
ValueAggregator