Re: Database structure for a "Document Management System"
Michelangelo Rezzonico Wrote:
> I am convinced that the third solution is the correct solution.
Not everyone would agree with you. Search the web for "entity attribute value"
> Note that I have created the index on column "document_id" of the table document_fields_link.
Your query might benefit from a composite index on (document_field_id, document_id).
What is the result of
EXPLAIN SELECT ... \G
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Written By
Posted
November 17, 2006 07:37AM
Re: Database structure for a "Document Management System"
November 20, 2006 03:26AM
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.