Search
scanning
Scanning is the default search option for small tables.
Enter text here to perform a scan over supported column types.
Text columns with limited length use a substring search
If the entered text is a number, integer columns will be scanned for an exact match of the value.
seeking
Seeking is the default search option for large tables.
Seeking requires indexes and can only be done using the column (or columns) the index is defined on.
In the single-column case, the database will seek to the position the entered search term would be at and
return all rows greater or equal to that value.
In the multiple-column case, the above still applies to the column you supplied non-empty search text for.
All previous columns, however, will be using an equality match.
There are no suitable indexes to seek by.
Note that there are some explanatory texts on larger screens.