Re: Select not using primary key index

On Thu, 14 Mar 2002 00:07:54 -0300, Sergio Freue <sfreue@yahoo.com>
wrote:
>create table testBig (id1 smallint not null,id2 smallint not
>null,primary key (id1, id2));
>
>Add about 1,500,000 records
>[...]
>select * from testBig where id1 = 1585 and id2 = 42;

select *
from testBig
where id1 = 1585::smallint and id2 = 42::smallint;

HTH,
 Carl van Tast