Adjacency List
The most common pattern. Each row contains a pointer to its parent.
check Simpleclose Deep Reads Hard
account_tree Logical Structure
Interactive
1
Electronics
2
Computers
6
Cameras
7
Phones
3
Laptops
4
Desktops
8
Smart
9
Feature
10
Rotary
5
Towers
Regular Node
Selected / Result
database Table: Categories
READ-ONLYOperation Simulation
code
Select an operation above to see the query logic.