RE: Do you rebuild your indexes every night or do you leave them alone.

Checking the health of indexes and refreshing statistics in an MS-SQL environment is a best practice.

https://ola.hallengren.com/

--

rk -----Original Message----- From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, November 09, 2016 12:22 PM To: profoxtech@leafe.com Subject: Re: Do you rebuild your indexes every night or do you leave them alone.

Life in a file server world compared to your data in a rdbms where you only get data through the api.

I haven't reindexed a table in my SQL servers in probably 10 years outside of freeing up wasted pages after a purge of a company's transaction data we sold off.

On Wed, Nov 9, 2016 at 5:18 AM, Ted Roche tedroche@gmail.com wrote: