On Sat, 22 Oct 2011 15:17:23 +0200, Fabian
wrote:
>I have a very simple table: it just contains one single (text) column with
>an index. This table contains million of hash-values, and because of the
>index, SQLite is storing all the data twice. Behind the scenes it creates a
>second table, conta
On Oct 22, 2011, at 3:17 PM, Fabian wrote:
> So is there some way to have a 'stand-alone index', which doesn't store
> everything twice?
Not in SQLite, no.
Other databases (such as Oracle) sometime offer so-called Index Organized Table
(IOT).
http://www.orafaq.com/wiki/Index-organized_table
On 22 Oct 2011, at 2:17pm, Fabian wrote:
> I have a very simple table: it just contains one single (text) column with
> an index. This table contains million of hash-values, and because of the
> index, SQLite is storing all the data twice. Behind the scenes it creates a
> second table, containing
I have a very simple table: it just contains one single (text) column with
an index. This table contains million of hash-values, and because of the
index, SQLite is storing all the data twice. Behind the scenes it creates a
second table, containing all the same values in sorted order, causing the
d
4 matches
Mail list logo
