One or Two tables ?

[yehonatan_boaz]

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

[FredericGirod]

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.

[yehonatan_boaz]

• 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

[Abinathsiva]

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