(Sorry for reposting...)
> You said you enter some rows, but how many rows got returned by your
query?
You're right, it does make all the difference. With only a few rows,
indexing is somehow used in the first case only (for my example), but with
larger tables index scan is used in both ways.
Hi,
I have created the following test table:
create table history (event_id int8 not null, event_type int, event_name
char(10), event_ts timestamp, user_data_ref int8);
I've populated the table with 20,000,000 rows.
I have created an index table:
create index history_idx on history (eve
