[sqlite] Is it faster with descending index

[Richard Hipp]

On 5/5/16, Ertan K???ko?lu <ertan.kucukoglu at 1nar.com.tr> wrote:
>
> Table create SQL:
> CREATE TABLE URUN(
>  Barkod Char(30) NOT NULL PRIMARY KEY,
>  ...
> );
>
> My question is, if I add following index, will it make my searches faster?
>
> CREATE UNIQUE INDEX IDX_BARKOD_DESC ON URUN(BARKOD);

No.

But if you change your table schema to read:

  CREATE TABLE URUN(
     Barkod char(30) PRIMARY KEY,
     ....
  ) WITHOUT ROWID;

Then it might well generate a smaller and faster database.  It seems
like it is worth a try, anyhow.
-- 
D. Richard Hipp
drh at sqlite.org