RE: [sqlite] How is the Index table in sqlite?

[B V, Phanisekhar]

Sorry for the spelling mistake in the subject.

Regards,
Phani

-----Original Message-----
From: B V, Phanisekhar 
Sent: Thursday, September 13, 2007 3:53 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] How is the Index stable in sqlite?

Database configuration:

Tables:

Create table maintable(column1 INTEGER, column2 INTEGER, column3
INTEGER).

Indices:

Create index column1idx on maintable (column1);

 

How does the index table look like in sqlite?

 

c-r

1-3

3-4

3-6

3-7

5-1

5-8

6-2

 

Or 

 

c-rrrrr...

 

1->3

3->4-6-7

5->1-8

6-2

 

I believe it looks like the first one. And if I am right, I would like
to know the problem with the second (which seems memory efficient)?

 

Regards,

Phani


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------