Skip to content

Conversation

Mytherin
Copy link
Collaborator

D FROM duckdb_optimizers();
┌────────────────────────────┐
│            name            │
│          varchar           │
├────────────────────────────┤
│ expression_rewriter        │
│ filter_pullup              │
│ filter_pushdown            │
│ regex_range                │
│ in_clause                  │
│ join_order                 │
│ deliminator                │
│ unnest_rewriter            │
│ unused_columns             │
│ statistics_propagation     │
│ common_subexpressions      │
│ common_aggregate           │
│ column_lifetime            │
│ top_n                      │
│ compressed_materialization │
│ duplicate_groups           │
│ reorder_filter             │
│ extension                  │
├────────────────────────────┤
│          18 rows           │
└────────────────────────────┘

This is useful when combined with PRAGMA disabled_optimizers

@Mytherin
Copy link
Collaborator Author

CC @szarnyasg

@Mytherin Mytherin added the Needs Documentation Use for issues or PRs that require changes in the documentation label Nov 27, 2023
@github-actions github-actions bot marked this pull request as draft November 27, 2023 16:01
@Mytherin Mytherin marked this pull request as ready for review November 27, 2023 16:01
@Mytherin Mytherin merged commit 7d02d9c into duckdb:main Nov 28, 2023
@Mytherin Mytherin deleted the duckdboptimizers branch December 4, 2023 11:44
krlmlr added a commit to duckdb/duckdb-r that referenced this pull request Dec 14, 2023
Merge pull request duckdb/duckdb#9815 from Mytherin/duckdboptimizers
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Needs Documentation Use for issues or PRs that require changes in the documentation
Projects
None yet
Development

Successfully merging this pull request may close these issues.

1 participant