General
PromptBeginner5 minmarkdownQuality: 22
-- Expected impact: [e.g.
converts full table scan to index seek]
0
Explore
Find agent skills by outcome
115,884 skills indexed with the new KISS metadata standard.
Showing 24 of 115,884Categories: General
General
PromptBeginner5 minmarkdownQuality: 22
- Covering Index — Includes all query columns
avoids table lookup
0
General
PromptBeginner5 minmarkdownQuality: 22
- B-Tree Index — Default
best for equality/range queries
0
General
PromptBeginner5 minmarkdownQuality: 22
- 🔴 Filesort — In-memory/disk sort
expensive
0
General
PromptBeginner5 minmarkdownQuality: 22
- 🔴 Full Table Scan — No index used
highest cost
0
General
PromptBeginner5 minmarkdownQuality: 22
5. SELECT : [Column resolution
expressions evaluated]
0
General
PromptBeginner5 minmarkdownQuality: 22
- ✅ Index Seek — Efficient
targeted lookup
0
General
PromptBeginner5 minmarkdownQuality: 22
6. ORDER BY : [Sort operation
filesort risk?]
0
General
PromptBeginner5 minmarkdownQuality: 22
2. WHERE : [Filters applied
index usage predicted]
0
General
PromptBeginner5 minmarkdownQuality: 22
(e.g.
WHERE YEAR(created_at) = 2023)
0
General
PromptBeginner5 minmarkdownQuality: 22
- 🟡 [Medium] — Moderate impact
best practice violation
0
General
PromptBeginner5 minmarkdownQuality: 22
- 🟡 Wildcard leading LIKE — e.g.
WHERE name LIKE '%john'
0
General
PromptBeginner5 minmarkdownQuality: 22
- 📋 Sorting/Paging : ORDER BY
LIMIT/OFFSET requirements
0
General
PromptBeginner5 minmarkdownQuality: 22
⚠️ If schema or DB flavour is not provided
state assumptions clearly
0
General
PromptBeginner5 minmarkdownQuality: 22
- 📊 Aggregations : GROUP BY
HAVING
0
General
PromptBeginner5 minmarkdownQuality: 22
Before analysing or writing anything
confirm the scope:
0
General
PromptBeginner5 minmarkdownQuality: 22
- ⚡ Performance Goal : e.g.
sub-second response
0
General
PromptBeginner5 minmarkdownQuality: 22
query optimisation
execution planning
0
General
PromptBeginner5 minmarkdownQuality: 22
- Set payment frequency (e.g. weekly
monthly..etc) ${frequency}
0
General
PromptBeginner5 minmarkdownQuality: 22
✅ HikariCP (default in Spring Boot
fastest
0
General
PromptBeginner5 minmarkdownQuality: 22
❌ Jedis (older pattern
topology issues)
0
General
PromptBeginner5 minmarkdownQuality: 22
These are critical because they affect performance
scalability
0
General
PromptBeginner5 minmarkdownQuality: 22
6. When the user selects a term
generate a structured
0
General
PromptBeginner5 minmarkdownQuality: 22
5. After presenting the briefing
invite the user to choose
0