Dontopedia

CREATE INDEX idx_composite ON documents(document_id, other_column);

From Dontopedia, the open, paraconsistent wiki. (Last updated 2026-06-10.)

CREATE INDEX idx_composite ON documents(document_id, other_column); has 7 facts recorded in Dontopedia across 1 reference, with 1 live disagreement.

7 facts·5 predicates·1 sources·1 in dispute

Mostly:specifies columns(2), rdf:type(1), creates index(1)

Maturity scale raw canonical shape-checked rule-derived certified

Other facts (6)

The long tail: predicates that appear too rarely to warrant their own section. Filter or scroll to find a specific one. Each row links to its source.

6 facts
PredicateValueRef
Specifies ColumnsDocument Id Column[1]
Specifies ColumnsOther Column[1]
Rdf:typeSql Statement[1]
Creates IndexComposite Index[1]
Modifies TableDocuments Table[1]
Creates Index Namedidx_composite[1]

Timeline

Timeline axis is valid_time — when each source says the fact was true in the world, not when Dontopedia learned about it. Retracted rows are kept for provenance; coloured stripes indicate the context kind.

typebeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:SQLStatement
labelbeam/92543d72-590a-4046-bfef-11efb61dbbf5
CREATE INDEX idx_composite ON documents(document_id, other_column);
createsIndexbeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:composite-index
modifiesTablebeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:documents-table
createsIndexNamedbeam/92543d72-590a-4046-bfef-11efb61dbbf5
idx_composite
specifiesColumnsbeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:document-id-column
specifiesColumnsbeam/92543d72-590a-4046-bfef-11efb61dbbf5
ex:other-column

References (1)

1 references
  1. ctx:claims/beam/92543d72-590a-4046-bfef-11efb61dbbf5
    • full textbeam-chunk
      text/plain1 KBdoc:beam/92543d72-590a-4046-bfef-11efb61dbbf5
      Show excerpt
      CREATE INDEX idx_covering ON documents(document_id, title, content); ``` 3. **Primary Key or Unique Identifier**: Ensure that your table has a unique identifier, such as an auto-incrementing primary key, to uniquely identify each

See also

Keep researching

Missing something or suspicious of what's here? Kick off a research session — a Claude agent will investigate, cite its sources, and file new facts into a dedicated context you can review before accepting into the shared view.