16 Nov
2005
16 Nov
'05
2: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