[Pansophy] Oracle Database

[Valerie Bookwalter]

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>
Sent: Friday, May 1, 2020 10:59 AM
To: Valerie Bookwalter <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/c2a91931/attachment.html>