update indices for better tax report performance

1 files changed, 4 insertions, 2 deletions

diff --git a/FS/FS/Schema.pm b/FS/FS/Schema.pm
index aaca5ef3b..7fc208f18 100644
--- a/FS/FS/Schema.pm
+++ b/FS/FS/Schema.pm
@@ -334,7 +334,7 @@ sub tables_hashref {
       ],
       'primary_key' => 'billpkgnum',
       'unique' => [],
-      'index' => [ ['invnum'] ],
+      'index' => [ ['invnum'], [ 'pkgnum' ] ],
     },
 
     'cust_bill_pkg_detail' => {
@@ -433,6 +433,8 @@ sub tables_hashref {
       #'index' => [ ['last'], ['company'] ],
       'index' => [ ['last'], [ 'company' ], [ 'referral_custnum' ],
                    [ 'daytime' ], [ 'night' ], [ 'fax' ], [ 'refnum' ],
+                   [ 'ship_last' ], [ 'ship_company' ],
+                   [ 'county' ], [ 'state' ], [ 'country' ]
                  ],
     },
 
@@ -465,7 +467,7 @@ sub tables_hashref {
       'primary_key' => 'taxnum',
       'unique' => [],
   #    'unique' => [ ['taxnum'], ['state', 'county'] ],
-      'index' => [],
+      'index' => [ [ 'county' ], [ 'state' ], [ 'country' ] ],
     },
 
     'cust_pay' => {