学习记录 about 2022 HOT 3 OPEN

2022-03-28
Things every developer absolutely, positively needs to know about database indexing - Kai Sassnowski

In summary:

Indexes are B-Trees

Indexes are fast

Indexes make writes slow, don't use too many

Use explain to see for your query what indexes are (not) used and how

Consider what you are indexing, only the constant values which are indexed can help the query

Consider both what you are querying and what you are selecting

The order of columns in the index is important, indexes are left-to-right and must use a contiguous subset of columns in the index.

Use indexes which are specifically designed to serve the queries you are running, decide on the trade-off between adding more indexes (taking space, and reducing write performance), and just living with lower query performance for less-used queries.

from 2022.

2022-03-29 Tue

Arrays, slices (and strings): The mechanics of 'append'

SliceTricks

notes

Go Cookbook

from 2022.

2022-03-30

Go Cookbook Ch1 finish

文件属性

from 2022.