Re: [GENERAL] Request to share approach during REINDEX operation

2016-12-21 Thread Steven Winfield
>>> In my production system, there are lot of read write operation performed >>> every hour. >>Apologies if this sounds patronising but I just wanted to check - you know >>that indexes are updated automatically when write operations occur, right? >Yes. You are correct. OK - I think the folks her

Re: [GENERAL] Request to share approach during REINDEX operation

2016-12-21 Thread Vick Khera
On Wed, Dec 21, 2016 at 8:43 AM, Yogesh Sharma wrote: > I have responded on previously mail. > > apparently you started two separate threads... > In my production system, there are lot of read write operation performed > every hour. > That still doesn't answer why you feel you need to run rein

Re: [GENERAL] Request to share approach during REINDEX operation

2016-12-21 Thread Yogesh Sharma
Dear Steven, Thanks for your reply. Yes. You are correct. Regards, Yogesh On Wednesday, December 21, 2016, Steven Winfield < steven.winfi...@cantabcapital.com> wrote: > > In my production system, there are lot of read write operation > performed every hour. > > > > Apologies if this sounds patr

Re: [GENERAL] Request to share approach during REINDEX operation

2016-12-21 Thread Steven Winfield
> In my production system, there are lot of read write operation performed > every hour. Apologies if this sounds patronising but I just wanted to check - you know that indexes are updated automatically when write operations occur, right? This email is confidential. If you are not the intende

Re: [GENERAL] Request to share approach during REINDEX operation

2016-12-21 Thread Yogesh Sharma
Dear Vick, I have responded on previously mail. In my production system, there are lot of read write operation performed every hour. Regards, yogesh On Wednesday, December 21, 2016, Vick Khera wrote: > On Wed, Dec 21, 2016 at 4:02 AM, Yogesh Sharma > wrote: > > Also, every hour,i am performin