summaryrefslogtreecommitdiff
path: root/sql/DB2-indices.sql
blob: 6242935fd86f44a0fb54b94c98c9bd26cd39a1ea (plain) 
    

  1. create index ac_trns_trans_id on acc_trans (trans_id)@
    2. 

  2. create index ac_trns_chart_id on acc_trans (chart_id)@
    3. 

  3. create index ac_trns_transdate on acc_trans (transdate)@
    4. 

  4. create index ac_trns_source on acc_trans (source)@
    5. 

  5. create index ap_id_x on ap (id)@
    6. 

  6. create index ap_transdate_x on ap (transdate)@
    7. 

  7. create index ap_invnumber_x on ap (invnumber)@
    8. 

  8. create index ap_ordnumber_x on ap (ordnumber)@
    9. 

  9. create index ap_vendor_id_x on ap (vendor_id)@
    10. 

  10. create index ap_emp_id_x on ap (employee_id)@
    11. 

  11. create index ar_id_x on ar (id)@
    12. 

  12. create index ar_transdate_x on ar (transdate)@
    13. 

  13. create index ar_invnumber_x on ar (invnumber)@
    14. 

  14. create index ar_ordnumber_x on ar (ordnumber)@
    15. 

  15. create index ar_cust_id_x on ar (customer_id)@
    16. 

  16. create index ar_emp_id_x on ar (employee_id)@
    17. 

  17. create index assembly_id_x on assembly (id)@
    18. 

  18. create index chart_id_x on chart (id)@
    19. 

  19. create unique index chart_accno_x on chart (accno)@
    20. 

  20. create index chart_category_x on chart (category)@
    21. 

  21. create index chart_link_x on chart (link)@
    22. 

  22. create index chart_gifi_accno on chart (gifi_accno)@
    23. 

  23. create index cust_id_x on customer (id)@
    24. 

  24. create index cust_customer_id_x on customertax (customer_id)@
    25. 

  25. create index cust_custnum_x on customer (customernumber)@
    26. 

  26. create index cust_name_x on customer (name)@
    27. 

  27. create index cust_contact_x on customer (contact)@
    28. 

  28. create index employee_id_x on employee (id)@
    29. 

  29. create unique index employee_login_x on employee (login)@
    30. 

  30. create index employee_name_x on employee (name)@
    31. 

  31. create index exchrate_ct_x on exchangerate (curr, transdate)@
    32. 

  32. create unique index gifi_accno_x on gifi (accno)@
    33. 

  33. create index gl_id_x on gl (id)@
    34. 

  34. create index gl_transdate_x on gl (transdate)@
    35. 

  35. create index gl_reference_x on gl (reference)@
    36. 

  36. create index gl_description_x on gl (description)@
    37. 

  37. create index gl_employee_id_x on gl (employee_id)@
    38. 

  38. create index invoi_id_x on invoice (id)@
    39. 

  39. create index invoi_trans_id_x on invoice (trans_id)@
    40. 

  40. create index makmod_parts_id on makemodel (parts_id)@
    41. 

  41. create index oe_id_x on oe (id)@
    42. 

  42. create index oe_transdate_x on oe (transdate)@
    43. 

  43. create index oe_ordnumber_x on oe (ordnumber)@
    44. 

  44. create index oe_emp_id_x on oe (employee_id)@
    45. 

  45. create index orditems_trans_id on orderitems (trans_id)@
    46. 

  46. create index parts_id_x on parts (id)@
    47. 

  47. create index parts_partnumber on parts (partnumber)@
    48. 

  48. -- create index parts_desc on parts (description)@
    49. 

  49. create index partstax_parts_id on partstax (parts_id)@
    50. 

  50. create index vend_id_x on vendor (id)@
    51. 

  51. create index vend_name_x on vendor (name)@
    52. 

  52. create index vend_vendnum_x on vendor (vendornumber)@
    53. 

  53. create index vend_contact_x on vendor (contact)@
    54. 

  54. create index vendtax_vendor_id on vendortax (vendor_id)@
    55. 

  55. create index shipto_trans_id on shipto (trans_id)@
    56. 

  56. create index project_id_x on project (id)@
    57. 

  57. create index partsgroup_id_x on partsgroup (id)@
    58.
generated by cgit v1.2.3 (git 2.46.0) at 2024-11-05 03:02:41 +0000