Home » RDBMS Server » Performance Tuning » choose which index to be create (merged)
choose which index to be create (merged) [message #410998] Wed, 01 July 2009 08:13 Go to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
i have a table in which there are 162370 rows.
In this table there is a column name file_no.
there is duplication in file_no.
now i have to create index on file_no column.
please help me on urgent basic
choose which index to be create [message #411002 is a reply to message #410998] Wed, 01 July 2009 08:19 Go to previous messageGo to next message
suryakantnirala
Messages: 19
Registered: May 2009
Location: Mumbai
Junior Member
i have a table in which there are 162370 rows.
In this table there is a column name file_no.
there is duplication in file_no.
now i have to create index on file_no column.
please help me on urgent basic
Re: choose which index to be create [message #411022 is a reply to message #411002] Wed, 01 July 2009 08:45 Go to previous message
cookiemonster
Messages: 12422
Registered: September 2008
Location: Rainy Manchester
Senior Member
Duplicates won't stop you creating an index.
They will stop you creating a unique index which I assume is the real problem.
The only sensible thing to do in that case is to delete the duplicates.
Previous Topic: oracle 11g - 11.0.7.0
Next Topic: 9i cbo mode first_rows
Goto Forum:
  


Current Time: Thu Dec 08 20:33:47 CST 2016

Total time taken to generate the page: 0.19477 seconds