doubt in indexes



IBM's flagship relational database management system

doubt in indexes

Postby arun3sncet » Sat Sep 25, 2010 7:58 am

1. What is the use of indexes in DB2 ?,

what it will contain ?

why we using indexes ?

what is the need of indexes?





2. Difference between cartesian product and outer join?



i know it is very basic questions but ur answer could clear my funda.....
arun3sncet
 
Posts: 2
Joined: Sat Jul 17, 2010 8:04 pm
Has thanked: 0 time
Been thanked: 0 time

Re: doubt in indexes

Postby dick scherrer » Sat Sep 25, 2010 8:22 am

Hello,

What is the use of indexes in DB2 ?, direct access to rows
what it will contain ? the value to use to directly access rows
why we using indexes ? direct acess to rows
what is the need of indexes? access rows directly instead of sequentially

Difference between cartesian product and outer join? a cartesian product results when every row of table A is paired with every row of table B

i know it is very basic questions but ur answer could clear my funda.....
Yes. . . In fact more basic than we are able to properly support. We are a help forum. We do not the resources to teach people with no foundation at all. Suggest you spend the time to do a lot of reading or enroll in some training program.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post