HEAP tables can have more than one index, but indexes only match "=" and
"!=" -- so you can't use ">", "<", etc... Also, comparisons only match
the entire index, not the left-most prefix like MyISAM tables. There are a
few other quirks, also:
http://www.mysql.com/doc/en/HEAP.html
--jeff
> On
On Sunday 18 August 2002 04:17 pm, Rick Robinson wrote:
> Hi all,
> I'm testing using a HEAP table to maintain transient state in a high
> volume TP environment. So far, it looks promising, and I want to ask
> anyone about similar experiences and solicit some input.
>
> Some background:
> * I hav
