how to cache indexes in memory

[geobg]

Could someone please give the syntax or sample stmts to cache
indexes of a table to memory. I already have the tables cached.

Thanks in advance,

Geo

[sambavan]

CREATE [UNIQUE/BITMAP] INDEX schema.index_name
ON schema.table(cloumn1, ...)
STORAGE (BUFFER_POOL KEEP/RECYCLE);


The things in [ ] are optional. / means either or.

Hope this would help you,
Sam