-
Type: Improvement
-
Resolution: Fixed
-
Priority: Major - P3
-
Affects Version/s: None
-
Component/s: None
-
None
-
Fully Compatible
-
QO 2023-12-11, QO 2023-12-25, QO 2024-01-08, QO 2024-01-22
We can remember the chunk starting points and keep them consistent for the duration of the query in the hope that this will achieve greater degree of stability and repeatability of the sampling process. Before we issue any sampling queries, we issue a “chunk collection” query. Using the example above, this query will return 5 record ids. We will then store those in a vector. We’ll modify the sampling query above to effectively replace the PhysicalScan with Limit 5 with a ValueScan node which will sequentially return record ids. The rest of the sampling plan remains unchanged.