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] -----------------------------------------------------------------------------