Page 1 of 1

ram table question

Posted: Wed Dec 15, 2010 12:46 pm
by basement_addict
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?

Thanks

ram table question

Posted: Wed Dec 15, 2010 1:41 pm
by mark
There are no ram indices.

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.