uniqId is the same as rowid,
so you will get the same execution plans for ...where rowid=x and ... where
uniqId=x.
----- Ursprüngliche Mail ----
Von: chetana bhargav <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Gesendet: Mittwoch, den 11. Oktober 2006, 09:19:28 Uhr
Betreff: [sqlite] PK and rowid
Hi,
If I declare my column as, "uniqId integer primary key", now if I say
something like,
select * from tbl1 where uniqId=x;
Will the uniqId be same as rowid, making my table look ups faster as I am
using row id only. If not whats the way to assign my uniqId to the row id so
that my lookups would be faster.
...
Chetana.
---------------------------------
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail.
___________________________________________________________
Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail:
http://mail.yahoo.de
