New answers tagged sql
2
votes
Dynamically transform EAV data into standard SQL table
Is this a good approach or is it better not to use EAV model at all?
I think I'd be on strong ground in saying that most practitioners disfavour EAV, and find that its challenges outweigh its sole ...
- 7,442
3
votes
How to design a region table for localization standardizations with multiple criteria
Unfortunately, this is a base table that will be used in different scenarios
Whoops. Somebody screwed up doing the requirements analysis - welcome to the real world, where physical geography and ...
- 23.2k
1
vote
Do we have 2 logical query processings, one with indexes and one without indexes?
How is a sql query processed when there are indexes, that is, would
this behavior change?
That diagram describes a process for determining what data a given query will return. It has nothing to do ...
- 10.7k
9
votes
Do we have 2 logical query processings, one with indexes and one without indexes?
tl;dr: Query planners are a big deal.
In general, before an RDBMS backend executes a query,
it first plans the query.
There's more than one way to access the data,
and the planner evaluates some of ...
- 4,754
1
vote
Accepted
What is the best practice for hierarchical container - item relationship in a SQL database?
What is the best practice for hierarchical container?
You have already described it
with suggested schema and query.
This is a standard setup,
and you have it exactly right.
actual issue
... while ...
- 4,754
Top 50 recent answers are included