On 8/7/06, Mario Frasca <[EMAIL PROTECTED]> wrote:
I was a bit wondering: does the declaration 'primary key' actually produce an indexing? or does that happen only if I explicitly ask for a (unique) index?
It usually does create unique index for you. But in this case, INTEGER PRIMARY KEY, it only creates an alias to rowid, which is something that sqlite uses internally to identify rows and this index is always present. So in this case it doesn't create any new index-es, but rather references an existing one. I think in any other case unique index would be created as expected. -- Nemanja Corlija <[EMAIL PROTECTED]>
