hi i read the follwing line in oracle 9i documentation, Unique and primary keys can use non-unique as well as unique indexes. They can even use just the first few columns of non-unique indexes. i am planning to use a primary key constraint enforced by the first few columns of a non-unique index.any feedback or advice or gotchas in having such a setup. thanks sai