Re: Slow response to my query

--0000000000003de74805987d31ed
Content-Type: text/plain; charset="UTF-8"

Thanks Jean-Yves / Steven,
am using V12.

On Fri, Nov 29, 2019 at 3:21 PM Bzzzz <[email protected]> wrote:

> On Fri, 29 Nov 2019 12:09:04 +0100
> Goke Aruna <[email protected]> wrote:
>
> Oops, I forgot,
>
> as you're not using V.12, it might not be a bad idea to create  new
> columns and trigger(s) to pre-calculate all of the EXTRACT/2 you need.
>
> Jean-Yves
>

--0000000000003de74805987d31ed
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">Thanks Jean-Yves / Steven,<br></div><div>=
am using V12.<br></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" clas=
s=3D"gmail_attr">On Fri, Nov 29, 2019 at 3:21 PM Bzzzz &lt;<a href=3D"mailt=
o:[email protected]">[email protected]</a>&gt; wrote:<br></div><blockquote =
class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px sol=
id rgb(204,204,204);padding-left:1ex">On Fri, 29 Nov 2019 12:09:04 +0100<br=
>
Goke Aruna &lt;<a href=3D"mailto:[email protected]" target=3D"_blank">goksie=
@gmail.com</a>&gt; wrote:<br>
<br>
Oops, I forgot,<br>
<br>
as you&#39;re not using V.12, it might not be a bad idea to create=C2=A0 ne=
w<br>
columns and trigger(s) to pre-calculate all of the EXTRACT/2 you need.<br>
<br>
Jean-Yves<br>
</blockquote></div></div>

--0000000000003de74805987d31ed--