[Pansophy] Oracle Database

[Valerie Bookwalter]

David,

No we do not use Oracle's query rewrite statement.
What options does that give us? Any word on new database server?

Valerie

From: David Sheppard <sheppard at jlab.org>
Sent: Friday, May 1, 2020 11:13 AM
To: Valerie Bookwalter <bookwalt at jlab.org>
Subject: Re: Oracle Database

I specifically want to know if you use the query rewrite statement in your code.

________________________________
From: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Sent: Friday, May 1, 2020 11:04 AM
To: David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>
Cc: pansophy <pansophy at jlab.org<mailto:pansophy at jlab.org>>
Subject: RE: Oracle Database


David,



We use VIEWS, Bonnie wrote some and so did a student for our security keys. Is this what you are referring to?



Valerie



From: David Sheppard <sheppard at jlab.org<mailto:sheppard at jlab.org>>
Sent: Friday, May 1, 2020 10:59 AM
To: Valerie Bookwalter <bookwalt at jlab.org<mailto:bookwalt at jlab.org>>
Subject: Oracle Database



Good Morning Valerie,



Do you guys use the query rewrite function in oracle? I think you use materialized views, or you did in the past. If you don't use query rewrite, you may be able to save some funds using standard edition instead of enterprise edition. Let me know. Thanks.



David Sheppard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mailman.jlab.org/pipermail/pansophy/attachments/20200501/1e621112/attachment.html>