Hi guys , assuming there's a table called 'transactions' which contains more than 1 million records and normally will retrieve the records for monthly/yearly summary report. There are 5 fields within the 'transaction' table which are :
- transaction_ID (PRIMARY)
- transaction_Name
- transaction_Date
- transaction_Amount
- transaction_reference
Right now I would like to add indexing feature and I was wondering which use I take it as index for the effective way. Normally those summary report will sort by date. Is it take transaction_Date as non-cluster index n transaction_ID as unique cluster index. Hope able to get any assistance here. Thx a lot.
Best Regards,
Hans