"Steve" <steeeeev...@gmx.net> writes:
> I have a small question about the order of values in a query. Assume I have a
> table with the following fields:
> uid INT,
> data BIGINT,
> hits INT
> And an unique index on (uid, data). I use libpq C API to query data from the
> table. The query is something like this:
> SELECT uid,data,hits FROM mytable WHERE uid=2 AND data IN
> (2033,2499,590,19,201,659)
> Would the speed of the query be influenced if I would sort the data? I can
> imagine that just querying a bunch of bigint would not make a big difference
> but what about several thousand of values? Would sorting them and sending the
> SQL query with ordered data influence the speed of the query?
It's unlikely to make enough difference to be worth the trouble.
regards, tom lane
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
