From: kennedy-downwithspammersfamily@attbi.net   
      
   "Vissu"  wrote in message   
   news:2bedd6a7.0403032012.2899a4a6@posting.google.com...   
   > Hi ,   
   >   
   > We will have about 50 tables. Some tables will be huge (severel   
   > million rows) and some are small but most of them will have about a   
   > million rows. For best performance of the database, how many   
   > tablespace should I have. I was thinking of using Locally Managed   
   > tablespaces (uniform extents) for both data and indexes.   
   >   
   > Can anyone share some experiences? Any other tips on layout of the   
   > database will be appreciated. Thanks   
   >   
   > Vissu   
   What version?  Use locally managed with auto managed extents and put the   
   data all in one tablespace.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)