create_index — 2 Technical Articles

Mar 10, 2026 · Databases

How Lance Builds Scalar and Vector Indexes: A Deep Dive into create_index

This article explains how Lance's Python API creates scalar and vector indexes, walks through the internal Rust implementation of the create_index workflow, and details the transaction, commit, and error‑handling mechanisms that ensure atomic and consistent index creation.

IndexingLanceRust

0 likes · 12 min read

How Lance Builds Scalar and Vector Indexes: A Deep Dive into create_index

ITPUB

Mar 3, 2016 · Databases

Mastering SQL Server Index Creation, Maintenance, and Optimization

This article explains why proper index design is crucial for SQL Server performance and provides detailed guidance on creating clustered and non‑clustered indexes, using ALTER INDEX to disable, rebuild, reorganize, and modify index metadata, as well as a comprehensive overview of index options and best‑practice recommendations.

ALTER INDEXIndex ManagementSQL Server

0 likes · 16 min read

Mastering SQL Server Index Creation, Maintenance, and Optimization