IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2-Secondary key help


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
kriz_cts

New User


Joined: 03 Aug 2005
Posts: 23

PostPosted: Thu Aug 18, 2005 6:27 pm
Reply with quote

Hi folks,
What is a secondary key? How it is useful...
Back to top
View user's profile Send private message
Karthikt

New User


Joined: 15 Aug 2005
Posts: 51

PostPosted: Thu Aug 18, 2005 6:57 pm
Reply with quote

Secondary key will be used as searck key and normally it returns too many rows.

e.g. If a database contains employee information where emp-id is primary key. then emp-name can be secondary which will be useful where one want to know the employee information starting with a particular name. It is useful in reducing the query time.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Execute secondary panel of sdsf with ... CLIST & REXX 1
No new posts DL/I status code AK for GU call using... IMS DB/DC 1
No new posts Secondary index error while loading d... IMS DB/DC 2
No new posts Query on secondary index IMS DB/DC 1
No new posts SFTP to primary and secondary servers JCL & VSAM 4
Search our Forums:

Back to Top