Jobs in Pune | Work better in teams | Socialize with friends | Submit Q&A | Tell a friend

Search site for 

• The question is not correct.
  “What structure can you have the database make to speed up table reads ?”
  It is not cleare what exectly the term
  “structure” means in this case.
  Follow the rules of DB tuning we have to:
  1] properly use indexes ( different types of indexes)
  2] properly locate different DB objects
  across different tablespaces, files and so on.
  3] create a special space (tablespace) to locate some of the data with special datatype
  ( for example CLOB, LOB and …)
  4]…
  5]…
  .
  So the question is not correct and answer cannot be short and sharp.

   987 Views  |   (3 votes, avg: 4.33)

   Loading ...
    

Answer »

1. Submitted By: tigerzuchini — October 6, 2006 not yet rated   + -

   Adding to the above :

   You’ll also want to *denormalize* your database tables.

3. Leave an Answer/Comment

   Name (required)

   Mail (will not be published) (required)

   Your Answer

   To prove you're a person (not a spam script), type the security text shown in the picture. Click here to regenerate some new text.
   

Contact Us | FAQ | Sitemap | Terms of Use | Privacy Policy | Tell a Friend

Copyright © 1999-2006 Jeeve Technologies LLC. All rights reserved.