What Is a Drill Index? | Bit Storage, Sorted

A drawer of loose drill bits turns a quick project into a guessing game the moment you need one specific size and can’t trust the stamped numbers. In everyday use, what a drill index is comes down to a simple organizer: a labeled case that holds drill bits in numbered size order, marked in inch, metric, or wire gauge ranges. The same term shows up in Apache Drill database software too, where an index is a different thing entirely.

What a Drill Index Does

A drill index is exactly what the name says: a case or organizer with one labeled slot per bit size. Each bit sits in its own spot, usually with the size stamped beside it, so you can see at a glance that the 3/8-inch bit lives in the third row and the 1/4-inch bit lives two slots over.

Indexes are grouped by measuring system. Fractional-inch sets cover common US sizes, metric sets match import tools and machinery, and wire-gauge indexes use numbered sizes for specialized work. The catalog range on most product pages lists which system the index uses, and compatibility rarely goes beyond that — if you buy a metric index, plan on metric bits.

A common starting size is the 19-piece index, which holds every bit most people need for routine maintenance. Index cases come as rigid plastic hinged boxes, metal organizers, or fold-out wallets, and the labels are usually molded or printed right into the slot. Worn stamping is the main reason an old index becomes annoying — a fresh case keeps the size legible exactly where the bit lives.

What Is an Apache Drill Index?

An Apache Drill index is a structure on a table that holds a subset of columns sorted by key values, which lets the query planner find rows without scanning the whole table. Index-based query plans are supported starting in Drill 1.15, which can use primary or secondary indexes to build them. Primary indexes organize the table’s main key, while secondary indexes are built on other columns and point back to the primary data.

Drill distinguishes between covering and non-covering indexes. A covering index contains every column a query needs; a non-covering index holds only part of them and may join back to the base table. Drill’s documentation also describes non-hashed indexes, which suit conditional queries with ORDER BY, and hashed indexes, which don’t guarantee sort order but spread writes across logical partitions to avoid hot spots. Functional indexes can be built on expressions such as CAST functions — the docs use CAST(zip_code as BIGINT) as an example. Indexes aren’t always faster, though: Drill’s planner may choose a full table scan when that is more cost efficient. Apache Drill’s query-index documentation explains the system in full.

How To Choose a Drill Index Set

Match the index to the bits you actually use. Fractional-inch sets are the usual default for American home and garden work; metric sets make sense if you maintain imported equipment; wire-gauge ranges only matter for specialty jobs. Decide whether you want an index that comes pre-loaded with bits or an empty case that organizes the bits you already own — both formats are common.

Build quality follows price. A $10 case is fine for light use, while more expensive metal indexes survive drops and heavier shop work. If you keep bits in a toolbox or on a workbench, a case with a latch beats a friction lid, since one dropped open case scatters the whole set. If the product page states the size system, treat that as the compatibility limit; if it doesn’t, check before ordering. Standard drilling precautions apply once the bits are in your drill — eye protection and a firm grip on smaller sizes.

If you’re ready to buy, our tested roundup of drill index sets compares the leading options at a glance.