It's been a long time since I've done report development, but Im trying to come up with some standards. Also, I am not a DBA by any stretch of the imagination
Wondering about AG fields - Here are my below assumptions I'd assume are correct.
1) Is there any reason why I would not always use an index as field type?
2) Referring to question 1 - Would I only use an index on fields that are searched commonly, AKA - Account, SSN, Name, ETC.
3) Dates- Should they be filters?
4) "Dropdown Boxes" - should they be filters?
Wondering how everyone does it and if i can get some tips. In the mean time, I'll be hitting up mr google. Thanks