an K???ko?lu
-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Richard Hipp
Sent: Friday, May 6, 2016 12:51 AM
To: SQLite mailing list
Subject: Re: [sqlite] Is it faster with descending index
On 5/
Hi,
I am using SQLite version 3.9.2 on WinCE devices. I have below table in one
of my databases. Table sometimes holds 1.5 to 3 million records in it. That
database is reached for read-only purposes and created from scratch in a PC
if its contents needs to be updated. All database files, applicati
On 5/5/16, Ertan K???ko?lu 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 tab
3 matches
Mail list logo