Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Need to know the index concepts

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
rajulan

New User


Joined: 11 Jan 2008
Posts: 66
Location: India

PostPosted: Tue May 05, 2009 12:37 am    Post subject: Need to know the index concepts
Reply with quote

Hi All,

I am having so much of confusion regarding index and unique index. When do we declare unique index? When do we declare index? I know a table can have more index. What is the limit for that? Can we define the unique index and index together? I think if we mention primary key , then we declare index. So please explain me...i am preparing for DB2 Certification...but i do not have a clarity about index. please help me. I have gone through so many documents . but i could not understand.

Thanks,
Rajulan R.C
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 05, 2009 12:43 am    Post subject:
Reply with quote

Hello,

I believe this bit of understanding has become more difficult than necessary.

Indexes are a way to access data directly (keyed/indexed rather than sequential).

Some indexes may not contain duplicate entries. These are defined as unique indexes.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue May 05, 2009 1:37 am    Post subject:
Reply with quote

Hello,

Quote:
So please explain me...i am preparing for DB2 Certification...but i do not have a clarity about index.
Certification should follow qualification, not precede it. . .

You do yourself, your potential employer, and everyone who has been certified a great dis-service by even attending/taking/sitting for the certification exam before you are completely well-versed in all aspects of the product. . .

Said differently, beginners should not be certified icon_exclaim.gif
Back to top
View user's profile Send private message
Marso

REXX Moderator


Joined: 13 Mar 2006
Posts: 1250
Location: Israel

PostPosted: Tue May 05, 2009 2:23 am    Post subject:
Reply with quote

Definitely a beginner's beginning question icon_eek.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue May 05, 2009 6:52 pm    Post subject: Re: Need to know the index concepts
Reply with quote

Hi,
rajulan wrote:
When do we declare unique index?
Unique indexes.
Quote:
When do we declare index?
DB2 indexes
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6970
Location: porcelain throne

PostPosted: Tue May 05, 2009 7:04 pm    Post subject:
Reply with quote

Quote:
Said differently, beginners should not be certified


this seems to be a the modus operandi:

get the interview answers for the job, get the job, ask others to do their work.

get the certification answers, get the certificate, get the job, ask others to do their job.
Back to top
View user's profile Send private message
rajulan

New User


Joined: 11 Jan 2008
Posts: 66
Location: India

PostPosted: Wed May 06, 2009 12:21 am    Post subject: Reply to: Need to know the index concepts
Reply with quote

Quote:
Said differently, beginners should not be certified


I already completed 700 db2 udb certification.

In my experience i have seen people who has completed certification(some people) do not have much clarity(have something). Whatever we learn is little, there are plenty of things to learn in the world.

Thanks Anuj D I will go through the document . If i have a doubt i will come back.


Quote:
get the interview answers for the job, get the job, ask others to do their work.

get the certification answers, get the certificate, get the job, ask others to do their job.


In company , if any one working as Project Manager and Leader and a Sw engg, they will have a doubt about basics some times. It does not mean that they are not eligible to be a PM and PL.

It does not seem to be what you think.

Thanks,
Rajulan R.C
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Wed May 06, 2009 1:38 am    Post subject:
Reply with quote

Hello,

Quote:
In company , if any one working as Project Manager and Leader and a Sw engg, they will have a doubt about basics some times. It does not mean that they are not eligible to be a PM and PL.
I completely agree. . . icon_smile.gif However, this has nothing to do with certification (imho). Many of the very best managers i've worked with have doubts about certain technical specifics - but they are also not trying to be certified.

From my first reply:
Quote:
. . .
Indexes are a way to access data directly (keyed/indexed rather than sequential).

Some indexes may not contain duplicate entries. These are defined as unique indexes.
Do you have the info you want from your original question?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Confusion b/w index and subscript Deepak kumar25 Mainframe Interview Questions 7 Thu Aug 31, 2017 6:50 am
No new posts SQL - select data available in index Nileshkul DB2 3 Mon Jun 26, 2017 1:30 am
No new posts setting new limit Key values for inde... srilata83 DB2 1 Fri Feb 10, 2017 9:24 pm
No new posts Order BY AND Index Nileshkul DB2 2 Sat Dec 31, 2016 6:33 pm
No new posts Several errors during building altern... Andi1982 JCL & VSAM 11 Wed Jul 06, 2016 7:39 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us