Re: Detect missing combined indexes (automatically)

2019-01-15 Thread Julien Rouhaud
Hi, On Tue, Jan 15, 2019 at 10:22 AM Thomas Güttler wrote: > > Hi Julien Rouhaud, > > powa can handle multi-column indexes now? Great news. This must be a new > feature. I checked this roughly one year ago and it was not possible at this > time. > Thank you very much powa! Oh, that's unexpected

Re: Detect missing combined indexes (automatically)

2019-01-15 Thread Thomas Güttler
at 8:20 AM Thomas Kellerer wrote: Thomas Güttler schrieb am 10.01.2019 um 13:56: Is there a way to detect missing combined indexes automatically I am managing a lot of databases and I think a lot of performance could get gained. But I don't want to do this manually. My focus is on mi

Re: Detect missing combined indexes (automatically)

2019-01-13 Thread Julien Rouhaud
On Mon, Jan 14, 2019 at 8:20 AM Thomas Kellerer wrote: > > Thomas Güttler schrieb am 10.01.2019 um 13:56: > > Is there a way to detect missing combined indexes automatically > > > > I am managing a lot of databases and I think a lot of performance > > could get gaine

Re: Detect missing combined indexes (automatically)

2019-01-13 Thread Thomas Kellerer
Thomas Güttler schrieb am 10.01.2019 um 13:56: > Is there a way to detect missing combined indexes automatically > > I am managing a lot of databases and I think a lot of performance > could get gained. > > But I don't want to do this manually. > > My focus is on mi

Detect missing combined indexes (automatically)

2019-01-10 Thread Thomas Güttler
Is there a way to detect missing combined indexes automatically I am managing a lot of databases and I think a lot of performance could get gained. But I don't want to do this manually. My focus is on missing combined indexes, since for missing single indexes there are already tools avai