Indexing
Everything on SkillVeris tagged Indexing — collected across the glossary, study notes, blog, and cheat sheets.
18 resources across 3 libraries
Study Notes(14)
Arrays in Fortran
Declaring, indexing, sectioning, and efficiently looping over Fortran's column-major arrays.
Arrays in Pascal
Learn how Pascal's fixed-size, strongly-typed arrays work, from simple index ranges to multidimensional matrices.
Indexing and Slicing in MATLAB
Master subscript and linear indexing, colon-based slicing, the end keyword, and logical indexing to access and filter matrix data efficiently.
Vectors in R
Learn how R's core data structure — the atomic vector — stores, indexes, and vectorizes operations over ordered collections of same-typed values.
Arrays in Julia
Learn how Julia's built-in Array type stores, indexes, and mutates collections of data, and why column-major memory layout matters for performance.
Indexing Strategies
Practical guidance for deciding what to index, how to order multicolumn indexes, and how to validate index effectiveness in PostgreSQL.
Bulk Indexing
Learn how the _bulk API batches index, update, and delete operations into a single request for high-throughput ingestion.
Elasticsearch Performance Tuning
Practical techniques for tuning indexing throughput, query latency, and resource usage in Elasticsearch.
Aggregation Performance
Learn practical techniques for diagnosing and improving the performance of MongoDB aggregation pipelines, from index usage to explain plans.
Indexing Strategies and Tradeoffs
How to choose composite index column order, use covering indexes, and know when not to index.
Array Indexing and Slicing
NumPy supports basic slicing, fancy (array) indexing, and boolean masking, each with distinct rules about whether the result is a view or a copy.
Indexing with loc and iloc
Master the two primary pandas selection accessors — .loc for label-based indexing and .iloc for integer-position-based indexing — and the pitfalls of chained i…
Database Indexing at Scale
Explains how indexes accelerate queries via data structures like B-trees, and the tradeoffs of adding, maintaining, and choosing indexes on very large tables.
Arrays in Ruby
An in-depth look at Ruby's Array class — ordered, index-based collections that can hold mixed types and expose a huge Enumerable-powered method set.
Cheat Sheets(1)
Interview Questions(3)
What is an Index in a Database?
A database index is a data structure that speeds up read queries by letting the database find rows without scanning the entire table, at the cost of extra stor…
What is a Materialized View?
A materialized view is a database object that stores the physical result of a query on disk, unlike a regular view which recomputes its result every time it is…
How to Design a Log Aggregation System
A log aggregation system collects logs from many hosts via lightweight shippers, ships them through a durable buffer to decouple producers from indexing speed,…