- 
    Type:Improvement 
- 
    Resolution: Unresolved
- 
    Priority:Major - P3 
- 
    None
- 
    Affects Version/s: None
- 
    Component/s: None
- 
    None
- 
        Query Optimization
- 
        (copied to CRM)
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
- 
        None
Consider the following aggregation on a uniform collection with a [0,999999] (with an index onĀ {a:1}
[
	{
		"$match" : {
			"$and" : [
				{
					"a" : {
						"$gte" : 500000
					}
				},
				{
					"a" : {
						"$lte" : 700000
					}
				}
			]
		}
	},
	{
		"$sample" : {
			"size" : 25
		}
	}
]
This will examine 200001 documents, but in this case, only the record locator needs to be random sorted and 25 documents fetched after record locators are chosen.