IBM Mainframe Forum

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.....

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.