John Hick-456673 (5/6/2016)
Creating indexes for data in other environments that does not conform to a production-like spread just does not make any sense and accomplishes nothing.
Yes, it does - it depends on the usage of the data. If the environment is for reporting, the report queries may have entirely different needs than the UI application has. Same thing for analysis.
John Hick
Hmm, wouldn't you want reporting and analysis on data that came from production? It may have different schema for warehousing etc, but the contents would be the same as production, no?
Hakim Ali
www.sqlzen.com