Skip to Main Content
Product Suggestions
Status Shipped
Created by Andrew Ardron
Created on Mar 5, 2018

Add index to salestrans.transactiondate

This field was created to combine invoicedate, deliverydate and orderdate. So, its actually really useful but i think we just missed creating an index on it.

I am suggesting an index that combines this date and the transactiontype as you are likely to be doing both fairly often.

  • Attach files