Doesn't sqlite fts add indexes by default? This is how I'm making the schema: ```sql CREATE TABLE IF

Doesn't sqlite fts add indexes by default? This is how I'm making the schema:
CREATE TABLE IF NOT EXISTS transcripts (
    feed_id INTEGER REFERENCES feeds_metadata(feed_id),
    archive_date TEXT,
    archive_date_time TEXT,
    object_key TEXT,
    segment_start REAL,
    segment_end REAL,
    segment TEXT
);

CREATE VIRTUAL TABLE IF NOT EXISTS transcripts_fts USING fts5(segment);
image.png
Was this page helpful?