> If I do have UNIQUE in a col declaration, will creating another index
> on that column slow things down? Before I knew what you write above, I
> had gone ahead and create a UNIQUE INDEX on col b. I am not sure if
> that was slowing the operations, so I just want to confirm that.
Slows down writes and makes the database larger.
> Second, it seems logical that if I have UNIQUE then I don't have to
> declare NOT NULL. For example,
Not redundant. UNIQUE does not imply NOT NULL.
> If I have declared UNIQUE NOT NULL, should I go back and ALTER the
> table to just UNIQUE so as to not experience and perf hits?
In SQLite, ALTER can't do that. All it can do is add new columns or
change the name of an existing table.
__________________________________
Discover Yahoo!
Find restaurants, movies, travel and more fun for the weekend. Check it out!
http://discover.yahoo.com/weekend.html
