I am getting the following error when I query the index with a % operator.
Error:
Cannot alloc 1256276 bytes of memory: Cannot allocate memory in the function fdbix_readbuf
my query: tsql "set indexaccess=1;select count(Word) from idx_myindex where Word like '%90luncheon'";
There are 25000 hits if I search for the exact word luncheon against the table.
My table's cardinality is 12806035
and the sizes of idx_myindex files:
27G - idx_myindex.dat
4.5G - idx_myindex.btr
98M - idx_myindex.tok
Thank you in advance!
Error:
Cannot alloc 1256276 bytes of memory: Cannot allocate memory in the function fdbix_readbuf
my query: tsql "set indexaccess=1;select count(Word) from idx_myindex where Word like '%90luncheon'";
There are 25000 hits if I search for the exact word luncheon against the table.
My table's cardinality is 12806035
and the sizes of idx_myindex files:
27G - idx_myindex.dat
4.5G - idx_myindex.btr
98M - idx_myindex.tok
Thank you in advance!