Skip to Main Content
Product Suggestions
Status Shipped
Created by Andrew Ardron
Created on Feb 23, 2018

ESSENTIAL required Index on salestrans.transactiondate

This field was added clearly for a single search across all dates (invoice, delivery, order) but has no index. It needs one. It will be heavily used by customers and in PowerBI for filtering data sets. At the moment this is crazy innefieicnt on even modest datasets never mind the likes of vGroup

 

ALSO - add it to the list of common fields for sales transactions in Report Builder

  • Attach files