choose which index to be create (merged) [message #410998] |
Wed, 01 July 2009 08:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 Go to previous message](/forum/theme/orafaq/images/up.png) |
cookiemonster
Messages: 13937 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.
|
|
|