Re: Creating indexes on a large table

prg wrote:
> I have partition option - however would it make sense to partition
> table when all I have is 2 columns
>
> Why would indexing all columns be a recepie for disaster ?

Partitioning makes sense no matter the number of columns if there is sufficient number of rows that partition pruning will aid performance.

Indexing unnecessary columns adds a load to the system that serves no useful purpose.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)