Hi All,
Can you help on how I can create index on the Column "value" below.

I want to speed up my queries which look like :

select id, tstamp, value
from humidity_data_vti3
where value= < RandomValue>


I get following errors when i create index :

- Try (1)
create index idx1 on humidity_data (id, readings)
-ERROR
Return: -517 [Informix][Informix ODBC Driver][Informix]The total size of the index is too large or too many parts in index. (SQLExecDirect[-517] at ext\pdo_informix\informix_driver.c:268)


-Try (2)
create index idx1 on humidity_data (id, value)
-ERROR
Return: -352 [Informix][Informix ODBC Driver][Informix]Column (value) not found. (SQLExecDirect[-352] at ext\pdo_informix\informix_driver.c:268)

-Try (3)
create index idx1 on humidity_data (readings)
-ERROR
Return: -517 [Informix][Informix ODBC Driver][Informix]The total size of the index is too large or too many parts in index. (SQLExecDirect[-517] at ext\pdo_informix\informix_driver.c:268)

==========================================
SQLs for My Table :-
-=========================================
#####################################
create Database
#####################################
create database sensorTSDB


#####################################
Creating DBSpace :-
#####################################
execute function admin('create dbspace','dbspace1',
'/data/IBM/informixdemo/demo_on/dbspace1','100 MB','0');

#####################################
Creating container
#####################################
EXECUTE PROCEDURE TSContainerCreate('sensor_data_containerName', 'ol_ds_sri_dbspace','sensor_data_ts_subtype', 6000, 7000);

#####################################
Creating row type :-
#####################################
CREATE ROW TYPE sensor_data_ts_subtype (
tstamp datetime year to fraction(5),
value decimal(14,3)
);


#####################################
Create Table :-
#####################################
CREATE TABLE humidity_data (
id decimal(20,0) PRIMARY KEY NOT NULL,
readings TimeSeries(sensor_data_ts_subtype)
);


#####################################
create a Virtual view on the timeseries data :-
#####################################
EXECUTE PROCEDURE TSCreateVirtualTab('humidity_data_vti3', 'humidity_data',
'origin(2015-01-01 00:00:00.00000),calendar(ts_1min),container(sensor _data_containerName),threshold(10000),regular',1, 'readings');