| choose which index to be create (merged) [message #410998] |
Wed, 01 July 2009 08:13  |
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  |
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 |
cookiemonster
Messages: 13958
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
