HOW TO EXPLAIN SHORT CUT JOIN AND THETA JOIN?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vams_gk
shortcut join :it is direct join between source and
destination
example :country-->region--.city
we can coneect country and city using shortcut join
theta join :non equality condition between two tables
Is This Answer Correct ? | 6 Yes | 6 No |
How were the reports scheduled and how to resolve unexecuted documents?
how many reports have u created ? explain a few.
1 Answers InfoStep, Ness Technologies, TCS,
what will be the contents for a functional requirements specifications
Can we create universe with no cache??
date format in report like (22/5/2010 "3:20:15 am") like this i want to remove 3:20:15 remove from report how can we do this in bo xi r2
Can anybody tell How a report will burst into .pdf files? Thanks in advance .....Prakash
How do u Receive requiremnts from the client?
What are the join problems comes appart from loop,chasm & fan Traps
Difference between drill by and drill across with example?
How to create universe in business objects enterprise 11.5
what is xcelsius architecture?
HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?