When it can be used:
1. Exact matches:
2. Using wild card character (% or _) at the end:
3. Less effective, but still useful, using wild card character in the middle:
When it is useless:
When wild card character is used in the beginning:
8
20 reads
CURATED FROM
IDEAS CURATED BY
Similar ideas to Index on Text Columns
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:
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