title: Documentum: Oracle database Date time difference and I_LATEST_ FLAG
body: <p>I am not sure how to phrase technically properly.</p>
  
  <h2>Introductions</h2>
  
  <p>We are using documentum 6.0 and oracle 11g. I have try to search documentum using DQL and it fail miserablely in terms of performance even after index and tuning.</p>
  
  <p>Part of the reason is because how documentum translate ->  any (cat="abc" and cat ="aaa" and cat ="ccc") for repeating values</p>
  
  <p>I'm trying to find documents with cat="abc", cat ="aaa" and cat ="ccc", and it will translate into multiple exist in subqueries.</p>
  
  <p>There are also other reasons like joining table and etc.</p>
  
  <p>Therefore I decided to query the generated oracle table directly.</p>
  
  <h2>So far the POC seems rather successful but I have a  few issues</h2>
  
  <p>1) I realize the old version are stored in the same table and the newest record is mark by a "1" for I_LATEST_FLAG</p>
  
  <p>May I know where I can find a definition of all the  I_* column created by documentum?</p>
  
  <p>And can I trust that "I_LATEST_FLAG"=1 is always the most current version of a document?</p>
  
  <p>2) I realize the date and time provided by DQL via Documentum adminstrator is accurate but in oracle DB they are a few hours behind.</p>
  
  <p>May I know is there a proper solution to this issue?</p>
  
  <p>3) Anyone using the same solution as me? if so please share other issues that I should look at?</p>
  
  <p>Thank you.</p>