I create a ram table and add an index to to it. the next time I recreate the ram table the index already exists. Is there such a thing as a ram index to use with a ram table?
If the table is large enough to warrant an index it may be just as well to use a disk table and index. OS disk
caching will tend to keep a frequently used file in cache.