Results of 1 - 4 of about 4 for affecting (0.001 sec.)
- Logical Operators 12334
- The following logical operators are available: AND , OR and NOT . SQL uses a three-valued logic system with true , false and NULL . Note that logical operators involving NULL do not always evaluate to NULL . For example, NULL AND false will
...false true NULL NULL The operators AND and OR are commutative, that is, you can switch the left and right operand without affecting the result.... - https://man.mtool.work/duckdb/2.0/sql/expressions/logical_operators.html
- Indexing 8802
- DuckDB has two types of indexes: zonemaps and ART indexes. Zonemaps DuckDB automatically creates zonemaps (also known as min-max indexes) for the columns of all general-purpose data types . Operations like predicate pushdown into scan opera
...ffers if it has to evict memory. Thus, indexes can take up a significant portion of DuckDB's available memory, potentially affecting the performance of memory-intensive queries. Re-attaching ( DETACH + ATTACH ) the database containing indexes can mitigate... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- Enum Data Type 8358
- Name Description ENUM Dictionary representing all possible string values of a column The enum type represents a dictionary data structure with all possible unique values of a column. For example, a column storing the days of the week can be
...sing the following command: DROP TYPE ⟨enum_name⟩; Currently, it is possible to drop enums that are used in tables without affecting the tables. Warning This behavior of the enum removal feature is subject to change. In future releases, it is expected tha... - https://man.mtool.work/duckdb/2.0/sql/data_types/enum.html
- Command Line Client 7470
- Installation To use the DuckDB CLI client, visit the CLI installation page . The latest stable version of the DuckDB command line client is 2.0.0. Installation The DuckDB CLI (Command Line Interface) is a single, dependency-free executable.
...etion times may not always decrease linearly—estimates can increase when query execution becomes less predictable. Factors Affecting The Accuracy of Query Completion ETA Completion time estimates may be less reliable under these conditions: System resourc... - https://man.mtool.work/duckdb/2.0/clients/cli/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work