Thanks Hannu. I got your point.. But in my example `employee_id` won't be larger than `32767`.. So I am thinking of creating an index on these two columns - Any thoughts what wrong I am doing here?
create index employee_name_idx on test (employee_name);
create index last_modified_date_idx on test (last_modified_date);
As the chances of executing the queries on above is very minimal.. Very rarely, we will be executing the above query but if we do, I wanted system to be capable of doing it.
Now I can execute the below queries after creating an index -
select * from test where employee_name = 'e27';
select employee_id from test where employee_name = 'e27';
select * from test where employee_id = '1';
But I cannot execute the below query which is - "Give me everything that has changed within 15 minutes" . So I wrote the below query like this -
select * from test where last_modified_date > mintimeuuid('2013-11-03 13:33:30') and last_modified_date < maxtimeuuid('2013-11-03 13:33:45');
But it doesn't run and I always get error as -
Bad Request: No indexed columns present in by-columns clause with Equal operator