XPost: comp.database.oracle, comp.databases.ms-sqlserver, micros   
   ft.public.sqlserver.programming   
   From: kennedy-downwithspammersfamily@attbi.net   
      
   "Andy Reynolds"  wrote in   
   message news:Xtt2d.7869$XW.206@twister.socal.rr.com...   
   > I am looking for information, books, websites, etc that will help me   
   figure   
   > out the following things in MSSQL and Oracle:   
   >   
   > 1. Optimizing the database configuration itself.   
   > 2. Optimal table and index design.   
   > 3. Optimizing SQL statement lookups.   
   > 4. Anything else that might help to speed up our database applications.   
   >   
   > Any advice at all would be useful.   
   >   
   > Thanks alot.   
   >   
   > Andy Reynolds   
   > ajreynolds@san.no.spam.rr.com   (remove the no.spam to send email)   
   >   
   >   
   Optimize the application.   
       Use bind variables   
       Get data efficiently, use array interface.   
       Avoid unnecessary parsing.   
       write efficient queries.   
      
   If you don't do the above then the rest is useless or of little value.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)