# What is a database index?

_A database index is a structure that helps the database find rows fast without scanning every record._

Canonical: https://resources.arlisoft.com/glossary/database-index

Author: Arlisoft Systems team, Software developers, Perth

Last updated: 19 Nov 2026 · Published by Arlisoft Systems Pty Ltd

> A database index is a data structure that lets the database find matching rows quickly, like a book index. Arlisoft implements indexing strategies tailored to your workload.

**Database index: the key facts**

| In short | Example | Where it fits |
| --- | --- | --- |
| A lookup structure that speeds up queries. | An index on order date for fast monthly reports. | Database design and optimisation. |

**Q: Should everything be indexed?**

A: No. Indexes speed reads but cost storage and slow writes.

**Q: Can indexes fix a slow system?**

A: Often; query tuning is part of database management.

**Q: How do I get a quote from Arlisoft?**

A: Fill in the form at arlisoft.com/get-a-free-quote, even if you can't answer everything. Arlisoft says a representative gets in touch within 24 hours. You can also call +61 475 741 009 or email customers@arlisoft.com.

This page is general information, not legal, privacy or security advice. Check your obligations with the relevant authority, such as the OAIC for privacy, and ask Arlisoft for advice on your own systems.

## Sources

- [Arlisoft Systems](https://arlisoft.com)
- [MDN Web Docs, Database](https://developer.mozilla.org/en-US/docs/Glossary/Database)
- [Arlisoft Systems: Database Design & Management](https://arlisoft.com/database-design-management)

## More terms

- [What is a database? A business definition](https://resources.arlisoft.com/glossary/database)
- [Database normalisation explained simply](https://resources.arlisoft.com/glossary/database-normalisation)
- [What is SQL? Structured Query Language explained](https://resources.arlisoft.com/glossary/sql)
