What to keep in mind?
- Avoid using functions in WHERE clause on indexes when it is not needed
- Use LIMIT when partial results are needed
- Order of columns in Multi-Column Indexes is important
- Extra conditions in WHERE clause can ruin the use of index-only scan, which doesn't access the actual table at all. Even if the filter limits the results more, it requires more processing
- Use LIKE filters wisely as explained in the previous idea
8
25 reads
CURATED FROM
IDEAS CURATED BY
Similar ideas to What to keep in mind?
Single vs Concatenated Indexes
Terminology:
- Single Index = Single-Column Index
- Concatenated Index = Multi-Column Index
How indexes work:
- Index is used to find data fast, therefore it looks for the WHERE claus...
Order in Multi-Column Index Matters
Order of the columns matter.
The index is useless if the first column doesn't appear in the WHERE clause.
Example 1:
An index on (t, x) will not be used in this query:
- SELECT * FROM table WHERE...
Python data processing with pandas
Pandas is a Python language package, which is used for data processing. This is a very common basic programming library when we use Python language for machine learning programming. This article is an introductory tutorial to it. Pandas provide fast, flexible and expressive data structures with t...
Read & Learn
20x Faster
without
deepstash
with
deepstash
with
deepstash
Personalized microlearning
—
100+ Learning Journeys
—
Access to 200,000+ ideas
—
Access to the mobile app
—
Unlimited idea saving
—
—
Unlimited history
—
—
Unlimited listening to ideas
—
—
Downloading & offline access
—
—
Supercharge your mind with one idea per day
Enter your email and spend 1 minute every day to learn something new.
I agree to receive email updates