Hi guys,

if a create unique index on column, which is not primary key, it is make from this column, after put index on it, primary key ? Or, just to avoid duplicate data in this column?

Views: 122

Reply to This

Replies to This Discussion

Usually a unique index that is not a primary key is created to just avoid duplicate data. There can be cases where SQL access can happen via the unqiue index rather than primary index.

If the new column must be part of the primary key then it should be added there . But this all depends on application design. 

Thank you

Regards

Eswar

RSS

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

Db2 12 Migration Planning & Customer Experiences - Part 1

Started by Sandy Flippen in What's hot ? on Thursday. 0 Replies

Register Now! NEXT CONTENT! Upcoming double webcast Db2 12 Migration Planning and customer experiences. Live Q &A session! PART 1 http://ibm.biz/BdzKxv 24th Sept 11:00 AM EST PART 2…Continue

IBM Db2 Analytics Accelerator Workshop

Started by Sandy Flippen in What's hot ? on Tuesday. 0 Replies

IBM Db2 Analytics Accelerator WorkshopPeter Bendel and Ute BaumbachWhen: Thursday, Oct 24, 2019 14:00 to 17:00Where: TBD Price: FREELIMITED PLACES AVAILABLE PLEASE REGISTER ASAP ALLOCATED ON FIRST COME BASISAbstract:Join this complimentary workshop…Continue

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service