Hey any papers/resouces that explain how sql queries are implemented beneath the covers? The data structures, patterns used etc.?
YOE 14 TC 300k
Want to see the real deal?
More inside scoop? View in App
More inside scoop? View in App
blind
SUPPORT
FOLLOW US
DOWNLOAD THE APP:
FOLLOWING
Industries
Job Groups
- Software Engineering
- Product Management
- Information Technology
- Data Science & Analytics
- Management Consulting
- Hardware Engineering
- Design
- Sales
- Security
- Investment Banking & Sell Side
- Marketing
- Private Equity & Buy Side
- Corporate Finance
- Supply Chain
- Business Development
- Human Resources
- Operations
- Legal
- Admin
- Customer Service
- Communications
Return to Office
Work From Home
COVID-19
Layoffs
Investments & Money
Work Visa
Housing
Referrals
Job Openings
Startups
Office Life
Mental Health
HR Issues
Blockchain & Crypto
Fitness & Nutrition
Travel
Health Care & Insurance
Tax
Hobbies & Entertainment
Working Parents
Food & Dining
IPO
Side Jobs
Show more
SUPPORT
FOLLOW US
DOWNLOAD THE APP:
comments
So SQL has a grammar. The query engine uses this grammar to check syntax.
It concerts it into a parse tree, does optimizations based on statistics and then decides how query actually is run. It is a complex process.
I read this book for my thesis, awesome stuff
Database management systems
Complete Book. Prentice Hall.
There are many different ways the queries are implemented and the database actually decides this at runtime (ie whether to use a hash join vs nested loop when you use JOIN) and further this depends on the database engine and how the data is stored internally.