General
PromptBeginner5 minmarkdown
- Cover: font scaling
image optimization (srcset
0
Explore
Find agent skills by outcome
61,641 skills indexed with the new KISS metadata standard.
Showing 24 of 61,641Categories: Research & Learning, General, Data
General
PromptBeginner5 minmarkdown
- Handle: notches
safe areas
0
General
PromptBeginner5 minmarkdown
- Target: 60fps animations
<2.5s LCP
0
General
PromptBeginner5 minmarkdown
- Address: touch targets
tap gestures
0
General
PromptBeginner5 minmarkdown
Generate a **comprehensive
actionable development plan** for building a responsive web application
0
General
PromptBeginner5 minmarkdown
- Flawlessly adapts to: mobile (320px+)
tablet (768px+)
0
General
PromptBeginner5 minmarkdown
patterns
and cross-device performance optimization.
0
Data
PromptBeginner5 minmarkdown
· MySQL/PostgreSQL : %s or $1
$2...
0
Data
PromptBeginner5 minmarkdown
Database Flavour: [SPECIFY e.g.
PostgreSQL 15]
0
Data
PromptBeginner5 minmarkdown
· SQL Server : SET STATISTICS IO
TIME ON;
0
General
PromptBeginner5 minmarkdown
ON [table]([column1]
[column2]);
0
General
PromptBeginner5 minmarkdown
-- Expected impact: [e.g.
converts full table scan to index seek]
0
General
PromptBeginner5 minmarkdown
- Covering Index — Includes all query columns
avoids table lookup
0
General
PromptBeginner5 minmarkdown
- Composite Index — Multiple columns
order matters
0
General
PromptBeginner5 minmarkdown
- B-Tree Index — Default
best for equality/range queries
0
General
PromptBeginner5 minmarkdown
- 🔴 Filesort — In-memory/disk sort
expensive
0
General
PromptBeginner5 minmarkdown
- ✅ Index Seek — Efficient
targeted lookup
0
General
PromptBeginner5 minmarkdown
6. ORDER BY : [Sort operation
filesort risk?]
0
General
PromptBeginner5 minmarkdown
- 🔴 Full Table Scan — No index used
highest cost
0
General
PromptBeginner5 minmarkdown
5. SELECT : [Column resolution
expressions evaluated]
0
General
PromptBeginner5 minmarkdown
2. WHERE : [Filters applied
index usage predicted]
0
General
PromptBeginner5 minmarkdown
- 🟡 Wildcard leading LIKE — e.g.
WHERE name LIKE '%john'
0
General
PromptBeginner5 minmarkdown
- 🟡 [Medium] — Moderate impact
best practice violation
0
General
PromptBeginner5 minmarkdown
- 📋 Sorting/Paging : ORDER BY
LIMIT/OFFSET requirements
0