[Optional] Percentage of data set to scan to discover the schema.
SCANPCT is enabled by default. To disable it, set DBControl option SCANPCTOption to 1. To re-enable it, set SCANPCTOption to 0 or 2.
| scan_pct | Scanned |
|---|---|
| 0 (default) | First 100 MB of data set (file by file if there are multiple files). |
| Between 0 and 1 | First 100 MB of data set (file by file if there are multiple files). Then, scan_pct * 100% of first 1000 remaining files. |
| 1 | First 1000 files of data set. |
| scan_pct | Scanned |
|---|---|
| Less than 1 | First 100 MB of data set (file by file if there are multiple files). |
| 1 | First 16 MB of each file, up to 100 MB of data set. |
A higher scan_pct may increase schema accuracy, but it increases performance time.