indexing.md

Bookmarks tagged [indexing]

^{www.codever.land/bookmarks/t/indexing}

How to Create Database Indexes: Databases for Developers: Performance 12min

^{https://www.youtube.com/watch?v=7wLFr7ZnKPU&feature=emb_logo}

Indexes are one of the most common performance tools available. But how do you create one? And how does it help the database find your data faster?

Watch this video to learn how to create an index a...

• 📆 published on: 2020-06-15
• tags: oracle, database, indexing, sql

---

How to Create and Use Indexes in Oracle Database

^{https://blogs.oracle.com/sql/how-to-create-and-use-indexes-in-oracle-database}

Indexes. They're one of the most powerful and misunderstood aspects of SQL performance. In this post we'll look at the purpose of an index, how to create and choose choose your index type. Then finish...

• tags: oracle, sql, indexing

---

How does database indexing work?

^{https://stackoverflow.com/questions/1108/how-does-database-indexing-work}

Why is it needed?

When data is stored on disk-based storage devices, it is stored as blocks of data. These blocks are accessed in their entirety, making them the atomic disk access operation. Disk bl...

• 📆 published on: 2008-08-04
• tags: sql, database, performance, indexing, database-indexes

---