I have a table with about 10mln rows in it with a primary key and an index defined on it:

 create table test.test_table(   date_info date not null,   string_data varchar(64) not null,   data bigint   primary key(date_info, string_data));   create index test_table_idx   on test.test_table(string_data); 

I have a query that makes the use of the test_table_idx:

select distinct date_info from test.test_table where string_data = 'some_val'; 

The issue is that first time around it could take up to 20 seconds to run the query and < 2 seconds on any subsequent runs.

Is there a way to pull load the entire index into memory rather then have DB load information on first access?

I have a table with about 10mln rows in it with a primary key and an index defined on it:

create table test.test_table( date_info date not null, string_data varchar(64) not null, data bigint primary key(date_info, string_data)); create index test_table_idx on test.test_table(string_data); 

I have a query that makes the use of the test_table_idx:

select distinct date_info from test.test_table where string_data = 'some_val'; 

The issue is that first time around it could take up to 20 seconds to run the query and < 2 seconds on any subsequent runs.

Is there a way to pull load the entire index into memory rather then have DB load information on first access?