Re: [PERFORM] CREATING INDEX on column having null values

2012-12-05 Thread Willem Leenen
resql.org > Subject: [PERFORM] CREATING INDEX on column having null values > > Hi, > > > I have a partitioned table(partitioned on date) .There are about 1 million > insertions per day. There is a column called mess_id. This column is updated > .But update query is takin

[PERFORM] CREATING INDEX on column having null values

2012-12-05 Thread suhas.basavaraj12
Hi, I have a partitioned table(partitioned on date) .There are about 1 million insertions per day. There is a column called mess_id. This column is updated .But update query is taking huge time.When i checked , this column is not unique, and most of the time its having null . Say everyday out of