English 中文(简体)
指数化数据库: 就业指数?
原标题:Indexing SQLite database: Empty Index ?

我有一张单张桌子。 该表有三栏,我有兴趣将仅列一栏。

问题在于,当我进行索引编制时,我只想到一个的豁免指数表!

我正在使用<代码>SQLite Manager+-ons>。 这是在我确认指数之前出现的辛迪加:

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

我不知道这个问题是什么。 我用另一个数据库对这个工具进行了长时间的尝试,并做了罚款。

任何建议?

最佳回答

我们不能“见”数据库索引的内容。 没有与指数相对应的表格或表格结构。 因此,看不到这一点是空洞的。

如果CREATE INDEX指挥系统没有错误,你可以相信,该指数的建立,将继续由你补充、删除和更新数据时的库克特维持。

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.

问题回答

Try use VACUUM query. 它将彻底重建qlite数据库档案,并将重建所有指数,并重建所有ROWID等。





相关问题
adding an index to sql server

I have a query that gets run often. its a dynmaic sql query because the sort by changes. SELECT userID, ROW_NUMBER(OVER created) as rownumber from users where divisionID = @divisionID and ...

Linq to SQL nvarchar problem

I have discovered a huge performance problem in Linq to SQL. When selecting from a table using strings, the parameters passed to sql server are always nvarchar, even when the sql table is a varchar. ...

TableView oval button for Index/counts

Can someone help me create an index/count button for a UITableView, like this one? iTunes http://img.skitch.com/20091107-nwyci84114dxg76wshqwgtauwn.preview.jpg Is there an Apple example, or other ...

Move or copy an entity to another kind

Is there a way to move an entity to another kind in appengine. Say you have a kind defines, and you want to keep a record of deleted entities of that kind. But you want to separate the storage of ...

热门标签