Avoid SELECT *
From Dontopedia, the open, paraconsistent wiki. (Last updated 2026-06-10.)
Avoid SELECT * is specify only columns needed.
Mostly:rdf:type(3), content(1), description(1)
Maturity scale
raw canonical shape-checked rule-derived certifiedInbound mentions (8)
Other subjects in dontopedia point AT this entity as a value. These are inverse relationships — e.g. "X motherOf this subject" — and answer questions the forward facts can't. Grouped by predicate.
consistsOfConsists of(1)
- Five Strategies
ex:five-strategies
describesDescribes(1)
- Select Specific Columns
ex:select-specific-columns
hasSectionHas Section(1)
- Database Optimization
ex:database-optimization
impactedByImpacted by(1)
- Efficiency
ex:efficiency
incorporatesIncorporates(1)
- Optimized Query Example
ex:optimized-query-example
preventsPrevents(1)
- Select Specific Columns
ex:select-specific-columns
recommendedStrategyRecommended Strategy(1)
- Assistant
ex:assistant
selectedBySelected by(1)
- Columns
ex:columns
Other facts (13)
The long tail: predicates that appear too rarely to warrant their own section. Filter or scroll to find a specific one. Each row links to its source.
| Predicate | Value | Ref |
|---|---|---|
| Rdf:type | Recommendation | [1] |
| Rdf:type | Optimization Strategy | [2] |
| Rdf:type | Best Practice | [3] |
| Content | Specify only the columns you need instead of using SELECT * | [1] |
| Description | specify only columns needed | [2] |
| Problem | fetching-all-columns-inefficient | [2] |
| Rationale | table-may-have-many-columns | [2] |
| Affects | Columns | [2] |
| Improves | Efficiency | [2] |
| Condition | table-has-many-columns | [2] |
| Requirement | columns-actually-needed | [2] |
| Recommended by | Assistant | [2] |
| Optimizes | Table | [2] |
Timeline
Timeline axis is valid_time — when each source says the fact was true in the world, not when Dontopedia learned about it. Retracted rows are kept for provenance; coloured stripes indicate the context kind.
References (3)
ctx:claims/beam/e86f763f-d636-49fc-ae60-790b1d02125e- full textbeam-chunktext/plain1 KB
doc:beam/e86f763f-d636-49fc-ae60-790b1d02125eShow excerpt
- **Avoid SELECT ***: Specify only the columns you need instead of using `SELECT *`. ### 3. Database Configuration Tune your database configuration for optimal performance. - **Buffer Pool Size**: Increase the buffer pool size to cache mo…
ctx:claims/beam/1faa34af-f0a8-41ca-a40a-c9d71a0940c6- full textbeam-chunktext/plain1 KB
doc:beam/1faa34af-f0a8-41ca-a40a-c9d71a0940c6Show excerpt
Can someone help me optimize this query to reduce latency? ->-> 6,8 [Turn 8915] Assistant: Optimizing database queries is a great way to reduce latency and improve the overall performance of your feedback processing system. Here are severa…
ctx:claims/beam/15343e7d-963c-4ba5-b8e3-4849f280339c- full textbeam-chunktext/plain1 KB
doc:beam/15343e7d-963c-4ba5-b8e3-4849f280339cShow excerpt
#### Query Optimization 1. **Select Specific Columns**: Avoid using `SELECT *` and explicitly list the columns you need. ```sql SELECT document_id, title, content FROM documents WHERE document_id = 12345; ``` 2. **Analyze Que…
See also
Keep researching
Missing something or suspicious of what's here? Kick off a research session — a Claude agent will investigate, cite its sources, and file new facts into a dedicated context you can review before accepting into the shared view.