Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?

Answer Posted / vidya

Short cut Join providing an alternative path between two
tables,bypassing intermediate tables, leading to the same
result,regardless of direction. Optimizes query time by
cutting long join paths as short as possible.

Theta join Link tables based on a relationship other than
equality between two columns.

Is This Answer Correct ?    14 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

942


How to open a universe with out using the Designer ??

7487


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

1107


how get the grand total in master-detail report?

2186


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2007


Explain when we use aggregate awareness function in designer?

988


Can anybody tell me what are the tuning problems?

2004


What is top business?

1006


Explain in detail about type 2(scd),

1060


Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

975


What is the profile and package?

2257


What is Indexing? how did u implement indexing?

2386


Explain what are the steps to be taken to schedule the report?

1061


please explain me with the real time tables on how aggregate tables are created and how aggregate awareness is addressed to it.

1965


what is universe null

2374