9 lines
395 B
MySQL
9 lines
395 B
MySQL
|
--BEGIN TRANSACTION;
|
||
|
CREATE INDEX index_billsec ON v_xml_cdr(billsec);
|
||
|
CREATE INDEX index_caller_id_name ON v_xml_cdr(caller_id_name);
|
||
|
CREATE INDEX index_destination_number ON v_xml_cdr(destination_number);
|
||
|
CREATE INDEX index_duration ON v_xml_cdr(duration);
|
||
|
CREATE INDEX index_hangup_cause ON v_xml_cdr(hangup_cause);
|
||
|
CREATE INDEX index_start_stamp ON v_xml_cdr(start_stamp);
|
||
|
--COMMIT;
|