0

I use match and lookup statement to get topN respectively, the speed of lookup is obviously faster than match, using the profile, I found that the indexScan of match matches 20 million, while the TagIndexRangeScan of lookup only matches 1000, in this case is the topN result by lookup statement accurate?

ps: My understanding is that the topN operation is done on the result set of indexScan or TagIndexRangeScan.

0 Answers0