Skip to content

Instantly share code, notes, and snippets.

@iaoakes
Created October 24, 2018 18:11
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iaoakes/078a3e5d13ab49b817e3691964a7c735 to your computer and use it in GitHub Desktop.
Save iaoakes/078a3e5d13ab49b817e3691964a7c735 to your computer and use it in GitHub Desktop.
Indexes for v_xml_cdr
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);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment