Indexes are great for data retrieval but will slow data entry up.
Partitioning is a pain in the bum unless you have a huge database.
Best place for info is by doing a search on metalink and ready the notes and
whitepapers.

Good luck

-----Original Message-----
From: sunita sharma [mailto:[Email Address Removed] 28 February 2003 11:18
To: LazyDBA.com Discussion
Subject: which is better


Hi Group ,

I wanted to know which one of these wud increase the
performance of the database more. Where can i get info
on these.

1. indexing
2. partioning of tables
3. both

__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/

--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page