Skip to Content

One or Two tables ?

Hello,

For search and reports purposes I have table that I flatten data from couple of tables.

What better to do, add description for fields that in this table or create another table that will have relationship one to one with this table and will holds descriptions for those fields ?

And please add an explanation why you do you think so.

Best Regards

Eli

Add a comment
10|10000 characters needed characters exceeded

    • In a year I have about 3,000,000 entries.
    • The description only is not changing but values in table are changing every time the object has been modified (each object about 3-5 times) and there for the descriptions are changing.
    • I making a lot of reading of the value table to get better performance of user screens and I need a description to get better performance of screens and reports.
    • Because I making a lot of reading I have a multiple indexes on the table.
    • The system is running on Oracle DB
  • Does your description will change? that means does your description should be up-to-date if someone decide to change it?

    If yes, you must have two tables

    if no, you must have one.

    And for me the better is to have two tables with a CDS view.

    Performance means nothing without testing. It depends of your system, the quantities of data, the kind of data, the number of data in a row ...... so much parameters.

Related questions

1 Answer

  • Posted on Aug 06, 2020 at 07:14 AM

    Hi,

    It depends on the volume of data which tables are going to handle, even if all data kept on single table there won't be any performance issue if multiple Keys have been set for reading the records from table.

    If multiple tables are there again it is also depends on the key combination how it's created. please concentrate on Keys then performance will be automatically addressed.

    Regards,

    Abinath S

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.