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.