Re: Table design where every column can be in WHERE clause
Posted by: Peter Brawley
Date: August 05, 2020 11:54AM

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.

Options: ReplyQuote


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.