Results of 1 - 10 of about 10 for cost (0.003 sec.)
- Join Operations 13479
- How to Force a Join Order DuckDB has a cost-based query optimizer, which uses statistics in the base tables (stored in a DuckDB database or Parquet files) to estimate the cardinality of operations. Turn off the Join Order Optimizer To turn
...oximate_join_order_threshold = 16; Raising the threshold can lead to better join orders for queries with many joins at the cost of longer optimization times. Lowering it reduces optimization time for large joins. Even below the threshold, the optimiz... - https://man.mtool.work/duckdb/2.0/guides/performance/join_operations.html
- FROM and JOIN Clauses 10422
- The FROM clause specifies the source of the data on which the remainder of the query should operate. Logically, the FROM clause is where the query starts execution. The FROM clause can contain a single table, a combination of multiple table
...he expressions do not have to be equalities – any predicate can be used: Return the pairs of jobs where one ran longer but cost less: SELECT s1.t_id, s2.t_id FROM west s1, west s2 WHERE s1.time > s2.time AND s1.cost < s2.cost; Natural Joins Natural j... - https://man.mtool.work/duckdb/2.0/sql/query_syntax/from.html
- Agent Mode 9403
- New Agent mode was introduced in DuckDB 2.0. Agent mode renders the CLI's output for consumption by an AI coding agent rather than a human at a terminal. It produces compact Markdown tables with explicit result limits, machine-readable erro
...result was read, an order-independent hash of the result. Emits errors as JSON on stderr . Renders compact query plans and cost estimates. Prints an estimate line and progress on stderr for a query that reads more than 1,000,000 rows. By default, a r... - https://man.mtool.work/duckdb/2.0/clients/cli/agent_mode.html
- Deploy as Native Image 9063
- Overview The JDBC driver runs inside GraalVM Native Image executables. Graal Native Image compiles a Java application ahead of time into a standalone binary that starts in milliseconds and requires no JVM on the target machine, which suits
...correctly from anywhere. This option produces a small executable, under 20 MB for a simple application, with no extraction cost when connections open. The library can be extracted from the driver JAR, or taken from the -nolib distribution together wi... - https://man.mtool.work/duckdb/2.0/clients/java/deploy_native_image.html
- Import Data 8384
- Overview The JDBC driver offers two ways to load data into DuckDB in bulk: the high-performance Appender and a JDBC batch writer. This page describes both and when to use each. Appender The Appender is available in the DuckDB JDBC driver vi
...does not improve performance. Prefer primitive columns over complex types. Nested types such as STRUCT , LIST , and UNION cost more per value than flat, primitive columns. A schema built from primitive columns appends fastest. Avoid allocating a Jav... - https://man.mtool.work/duckdb/2.0/clients/java/data_import.html
- Configuration 8384
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...ache_remote_min_block_size Reads of remote files are rounded out to aligned blocks of this size, so tiny reads do not each cost a request. UBIGINT 4096 external_file_cache_request_sizing How reads of cached files are sized: AUTO lets each reader choo...es BOOLEAN false parquet_prefetch_column_gap Byte gap under which Parquet prefetch I/O ranges are coalesced (NULL lets the cost model adapt it) UBIGINT NULL partitioned_write_flush_threshold The number of rows threshold after which a thread state is... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
- Azure Extension 7705
- The azure extension lets DuckDB read and write files in Azure Blob Storage and Azure Data Lake Storage (ADLS) Gen2. Installing and Loading The azure extension will be transparently autoloaded on first use from the official extension reposit
...ens. With 0 , all blocks are committed when the file is closed. Non-zero values make partial writes visible sooner, at the cost of extra requests. This option does not change the 50,000-block limit. UBIGINT 0 azure_transport_option_type Underlying ad... - https://man.mtool.work/duckdb/2.0/core_extensions/azure.html
- Iceberg Options 7705
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...sions). iceberg_use_metadata_log BOOLEAN true Use a table's optional metadata-log to preserve atomicity guarantees, at the cost of an additional metadata GET request in rare cases. iceberg_equality_delete_fast_filter BOOLEAN true Apply equality delet... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- ATTACH and DETACH Statements 7705
- DuckDB allows attaching to and detaching from database files. Examples Attach the database file.db with the alias inferred from the name ( file ): ATTACH 'file.db'; Attach the database file.db with an explicit alias ( file_db ): ATTACH 'fil
...). VARCHAR - RECOVERY_MODE Recovery mode for the database. no_wal_writes disables WAL writes, improving performance at the cost of crash recovery. VARCHAR - The options above apply when attaching DuckDB and SQLite database files. Attaching a database... - https://man.mtool.work/duckdb/2.0/sql/statements/attach.html
- Complete API 7025
- This page contains the reference for DuckDB's C API. The reference contains several deprecation notices. These concern methods whose long-term availability is not guaranteed as they may be removed in the future. That said, DuckDB's develope
...type ( duckdb_cast_function cast_function , duckdb_logical_type target_type ); void duckdb_cast_function_set_implicit_cast_cost ( duckdb_cast_function cast_function , int64_t cost ); void duckdb_cast_function_set_function ( duckdb_cast_function cast_... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work