Skip to content
Better HN
Top
Best
Ask
Show
New
Jobs
Search
⌘K
0 points
asadawadia
3y ago
0 comments
Save
Share
sql can be arbitrarily nested/deep - so how does the code 'know' what to do
0 comments
3 comments · 1 top-level
top
newest
oldest
captaintobs
3y ago
· 2 in thread
recursion!
https://github.com/tobymao/sqlglot/tree/main/sqlglot/optimiz...
asadawadia
OP
3y ago
Does this only optimize things like `select * from table where false` type stuff or can it optimize access paths as well? such as whether an index can be used? and what ranges? or should a sequential scan be used
captaintobs
3y ago
it can do everything that can be done with the query and schema. it doesn't yet do indices or physical statistics
j
/
k
navigate · click thread line to collapse