CODEWITHSUNDEEP
sqliteindexingsqlitemanager
iTurki
iTurki

Reputation: 16398

Indexing SQLite database: Empty Index ?

I have a .sqlite db which contains only one table. That table contains three columns and I am interested in indexing one column ONLY.

The problem is, when I perform the indexing, I got an empty index table !

I am using SQLite Manager add-ons for Firefox. This is the syntax that appears before I confirm the indexing:

CREATE  INDEX "main"."tableIndex" ON "table" ("column1" ASC)

I don't know what is the problem here. I tried this tool - long time ago - with another database and it works fine.

Any suggestion ?

Upvotes: 2

Views: 1546

Answers (2)

Larry Lustig
Larry Lustig

Reputation: 50970

You cannot "see" the contents of a database index. No table or table-like structure is created that corresponds to the index. So there is nothing to look at that could be empty.

If the CREATE INDEX command ran without error, you can be confident that the index was created and will continue to be maintained by SQLite as you add, remove, and update data.

As per the comments, below, @iturki is actually trying to index for full text search. SQLite supports several extensions for full text search but they are not implemented through the stanard CREATE INDEX command. See this reference.

Upvotes: 3

Serhii Mamontov
Serhii Mamontov

Reputation: 4932

Try use VACUUM query. It will completely rebuild sqlite database file and will rebuild all indices and reset all ROWID etc.

Upvotes: 1

Related Questions