用 Claude Sonnet 5.5 處理日常程式開發與文件工作

Claude Sonnet 5.5 輸出範例

以預設投入程度取得的回答，未經編輯。

Explain a database index to a new backend developer in three concise sentences. Include one trade-off.

A database index is a separate data structure (typically a B-tree) that stores the values of one or more columns in sorted order along with pointers to the corresponding rows, so the database can find matching rows without scanning the entire table. Think of it like a book's index: instead of reading every page to find a topic, you look it up and jump straight to the right place. The trade-off is that indexes speed up reads but slow down writes (INSERT, UPDATE, DELETE) and consume extra storage, because every change to the table must also be applied to each relevant index.

2026 年 10 月 1 日：輸入 65 token，輸出 170 token。結果可能不同。