# Collection Scan

*noun*

say it: **“kuh-LEK-shun SKAN”** **/kəˈlɛkʃən ˈskæn/**

Reading every record in a collection to find the ones a query asks for, which happens when no index can help.

## What is a **collection scan**?

A **collection scan** is MongoDB reading every document in a collection to check it against a query's filter, because no index fits the query. It's fine for a hundred documents and slow for a million; `explain()` shows it as `COLLSCAN`.

```javascript
db.orders.find({ customerId: 31 }).explain("executionStats");
// winningPlan: { stage: 'COLLSCAN', ... }
// executionStats: { nReturned: 12, totalDocsExamined: 50000, ... }
```

## In a sentence

- “explain() showed a **collection scan**: 50,000 orders examined to return 12.”
- “After createIndex, the **collection scan** became an index scan.”

Level: Journeyman · [More MongoDB terms at this level](https://www.ask-codey.com/glossary?category=mongodb&level=3)

Updated: November 19, 2026

Source: https://www.ask-codey.com/glossary/collection-scan
