Re: Table design where every column can be in WHERE clause
It'll be useful to gather sample queries for long enough to understand patterns & frequencies ... also column groupings & deoendencies.
You may need a lightly indexed OLTP version of the table for inserts & updates, and an OLAP version with indexes updated at off-peak times.
Subject
Written By
Posted
Re: Table design where every column can be in WHERE clause
August 05, 2020 11:54AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.