Re: Database structure for a "Document Management System"
Hi felix,
> Your query might benefit from a composite index on (document_field_id, document_id).
Thanks a lot for your answer !!
Problem solved.
> Not everyone would agree with you. Search the web for "entity attribute value"
In the first solution I need to create multiple join when I want to select all the tables.
In the second solution I see the advantage that I can create views that are modifiable.
In the third solution I can create views, but are not modifiable.
Which is the "best" solution, the second ?
What is your opinion ?
I am very interested in your opinion.
Best Regards. Michelangelo
Edited 37 time(s). Last edit at 11/20/2006 03:52PM by Michelangelo Rezzonico.
Subject
Written By
Posted
November 17, 2006 07:37AM
November 20, 2006 03:26AM
Re: Database structure for a "Document Management System"
November 20, 2006 07:10AM
November 20, 2006 03:47PM
November 21, 2006 01:56AM
November 21, 2006 12:26PM
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.