16 Nov
2005
16 Nov
'05
3:18 a.m.
Bjorn Asmul writes:
What indexes would you recommend on the LCR table?
the ones that are automatically installed:
CREATE TABLE lcr (
prefix varchar(16) NOT NULL,
from_uri varchar(128) NOT NULL DEFAULT '%',
grp_id INT UNSIGNED NOT NULL,
priority TINYINT UNSIGNED NOT NULL,
KEY Key1 (prefix),
KEY Key2 (from_uri),
KEY Key3 (grp_id)
) $TABLE_TYPE;
-- juha