Results of 1 - 10 of about 62 for Index (0.003 sec.)
- CREATE INDEX Statement 11646
- CREATE INDEX The CREATE INDEX statement constructs an index on the specified column(s) of the specified table. Examples Create a unique index films_id_idx on the column id of table films : CREATE UNIQUE INDEX films_id_idx ON films (id); Cre
...ate index s_idx that allows for duplicate values on column revenue of table films : CREATE INDEX s_idx ON films (revenue); Create in...dex if it does not yet exist: CREATE INDEX IF NOT EXISTS s_idx ON films (revenue); The CREATE INDEX IF NOT EXISTS statement does not have an “early exit” at the mome...nt, instead, it will attempt to create the index and only check its existence before committing it to storage. Therefore, it may run for a longer time compared to other IF... - https://man.mtool.work/duckdb/2.0/sql/statements/create_index.html
- Vector Similarity Search Extension 11183
- The vss extension is an experimental extension for DuckDB that adds indexing support to accelerate vector similarity search queries using DuckDB's new fixed-size ARRAY type. See the announcement blog post and the “What's New in the Vector S
...imilarity Search Extension?” post . Usage To create a new HNSW (Hierarchical Navigable Small Worlds) index on a table with an ARRAY column, use the CREATE INDEX statement with the USING HNSW clause. For example: INSTALL AND LOAD...T INTO my_vector_table SELECT array_value(a, b, c) FROM range(1, 10) ra(a), range(1, 10) rb(b), range(1, 10) rc(c); CREATE INDEX my_hnsw_index ON my_vector_table USING HNSW (vec); The index will then be used to accelerate queries that use an ORDER BY...clause evaluating one of the supported distance metric functions against the indexed columns and a constant vector, followed by a LIMIT clause. For example: SELECT * FROM my_vector_table ORDER BY array_dis... - https://man.mtool.work/duckdb/2.0/core_extensions/vss.html
- Indexing 11097
- 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
...23 or < 400 ). The Effect of Ordering on Zonemaps The more ordered the data within a column, the more valuable the zonemap indexes will be. For example, a column could contain a random number on every row in the worst case. Then, DuckDB will likely be...ind a specific UUID value. An ordered INTEGER column allows skipping all row groups except those containing the value. ART Indexes DuckDB allows defining Adaptive Radix Tree (ART) indexes in two ways. First, such an index is created implicitly for col...umns with PRIMARY KEY , FOREIGN KEY , and UNIQUE constraints . Second, explicitly running the CREATE INDEX statement creates an ART index on the target column(s). The tradeoffs of having an ART index on a column are as follows: A... - https://man.mtool.work/duckdb/2.0/guides/performance/indexing.html
- R-Tree Indexes 10707
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...not scale very well to large datasets as it always requires a full table scan to check every row in the table. However, by indexing a table with an R-tree, it is possible to accelerate these types of queries significantly. How Do R-Tree Indexes Work?...f a point is the point itself. By traversing the R-tree from top to bottom, it is possible to very quickly search a R-tree-indexed table for only those rows where the indexed geometry column intersect a specific region of interest, as you can skip sea...patial predicate check (and any other filters) only have to be executed for these rows. What Are the Limitations of R-Tree Indexes in DuckDB? Before you get started using the R-tree index, there are some limitations to be aware of: The R-tree index is... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Complete API 10577
- 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
..._create_config ( duckdb_config * out_config ); size_t duckdb_config_count (); duckdb_state duckdb_get_config_flag ( size_t index , const char ** out_name , const char ** out_description ); duckdb_state duckdb_set_config ( duckdb_config config , const...duckdb_result * result ); Result Functions duckdb_data_chunk duckdb_result_get_chunk ( duckdb_result result , idx_t chunk_index ); bool duckdb_result_is_streaming ( duckdb_result result ); idx_t duckdb_result_chunk_count ( duckdb_result result ); duc..._statement prepared_statement ); const char * duckdb_parameter_name ( duckdb_prepared_statement prepared_statement , idx_t index ); duckdb_type duckdb_param_type ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); duckdb_logical_type d... - https://man.mtool.work/duckdb/2.0/clients/c/api.html
- Full-Text Search Extension 10114
- Full-Text Search is an extension to DuckDB that allows for search through strings, similar to SQLite's FTS5 extension . Installing and Loading The fts extension will be transparently autoloaded on first use from the official extension repos
...ly, run: INSTALL AND LOAD fts; Usage The extension adds two PRAGMA statements to DuckDB: one to create, and one to drop an index. Additionally, a scalar macro stem is added, which is used internally by the extension. PRAGMA create_fts_index create_fts..._index(input_table, input_id, *input_values, stemmer = 'porter', stopwords = 'english', ignore = '(\\.|[^a-z])+', strip_accents =...1, lower = 1, overwrite = 0, incremental = 0) PRAGMA that creates a FTS index for the specified table. Name Type Description input_table VARCHAR Qualified name of specified table, e.g., 'table_name' o... - https://man.mtool.work/duckdb/2.0/core_extensions/full_text_search.html
- Indexes 9767
- Index Types DuckDB has two built-in index types. Indexes can also be defined via extensions . Min-Max Index (Zonemap) A min-max index (also known as zonemap or block range index) is automatically created for columns of all general-purpose d
...mainly used to ensure primary key constraints and to speed up point and very highly selective (i.e., < 0.1%) queries. ART indexes can be created manually using the CREATE INDEX clause and they are automatically created for columns with a UNIQUE or PR...IMARY KEY constraint. Warning ART indexes must currently be able to fit in memory during index creation. Avoid creating ART indexes if the index does not fit in m...emory during index creation. Indexes Defined by Extensions DuckDB supports R-trees for spatial indexing via the spatial extension. Persistenc... - https://man.mtool.work/duckdb/2.0/sql/indexes.html
- Types 8828
- DuckDB is a strongly typed database system. As such, every column has a single type specified. This type is constant over the entire column. That is to say, a column that is labeled as an INTEGER column will only contain INTEGER values. Duc
...ion on data chunks . API Reference Overview duckdb_data_chunk duckdb_result_get_chunk ( duckdb_result result , idx_t chunk_index ); bool duckdb_result_is_streaming ( duckdb_result result ); idx_t duckdb_result_chunk_count ( duckdb_result result ); duc..._enum_dictionary_size ( duckdb_logical_type type ); char * duckdb_enum_dictionary_value ( duckdb_logical_type type , idx_t index ); duckdb_logical_type duckdb_list_type_child_type ( duckdb_logical_type type ); duckdb_logical_type duckdb_array_type_chi...uct_type_child_count ( duckdb_logical_type type ); char * duckdb_struct_type_child_name ( duckdb_logical_type type , idx_t index ); duckdb_logical_type duckdb_struct_type_child_type ( duckdb_logical_type type , idx_t index ); idx_t duckdb_union_type_m... - https://man.mtool.work/duckdb/2.0/clients/c/types.html
- Values 8626
- The value class represents a single value of any type. API Reference Overview void duckdb_destroy_value ( duckdb_value * value ); duckdb_value duckdb_create_varchar ( const char * text ); duckdb_value duckdb_create_varchar_length ( const ch
..._value * values , idx_t entry_count ); duckdb_value duckdb_create_union_value ( duckdb_logical_type union_type , idx_t tag_index , duckdb_value value ); idx_t duckdb_get_map_size ( duckdb_value value ); duckdb_value duckdb_get_map_key ( duckdb_value v...alue , idx_t index ); duckdb_value duckdb_get_map_value ( duckdb_value value , idx_t index ); bool duckdb_is_null_value ( duckdb_value value...lue (); idx_t duckdb_get_list_size ( duckdb_value value ); duckdb_value duckdb_get_list_child ( duckdb_value value , idx_t index ); duckdb_value duckdb_create_enum_value ( duckdb_logical_type type , uint64_t value ); uint64_t duckdb_get_enum_value ( d... - https://man.mtool.work/duckdb/2.0/clients/c/value.html
- Prepared Statements 8337
- A prepared statement is a parameterized query. The query is prepared with question marks ( ? ) or dollar symbols ( $1 ) indicating the parameters of the query. Values can then be bound to these parameters, after which the prepared statement
...NTO integers VALUES ($1, $2)", &stmt) == DuckDBError) { // handle error } duckdb_bind_int32(stmt, 1, 42); // the parameter index starts counting at 1! duckdb_bind_int32(stmt, 2, 43); // NULL as second parameter means no result set is requested duckdb_..._statement prepared_statement ); const char * duckdb_parameter_name ( duckdb_prepared_statement prepared_statement , idx_t index ); duckdb_type duckdb_param_type ( duckdb_prepared_statement prepared_statement , idx_t param_idx ); duckdb_logical_type d...eturns the name used to identify the parameter The returned string should be freed using duckdb_free . Returns NULL if the index is out of range for the provided prepared statement. Syntax const char * duckdb_parameter_name ( duckdb_prepared_statement... - https://man.mtool.work/duckdb/2.0/clients/c/prepared.html
DuckDB 2.0 Documentation / man.mtool.work