How Do We Prevent A Cross-join? – InterviewSolution

InterviewSolution

1.

How Do We Prevent A Cross-join?

Answer»

Cross-Joins can be prevented by SETTING the VLDB property that does not ALLOW to EXECUTE a cross-join

Cross-Joins can be prevented by setting the VLDB property that does not allow to execute a cross-join

Discussion

No Comment Found

Related InterviewSolutions

What Is A Materialized View?
How To Reduce Multiple Passes To One In A Report?
I Have A Fact Table At All Time Levels(date, Week...year). I Have The Similar Fact Table At Year Level. If I Create A Report With A Fact Attribute And A Metric Based On That Fact........ How Do We Force The Mstr To Use Year Level Fact Table Instead Of Using The All-levels Fact Table?
If We Need To Restrict Certain Columns From Appearing To A User/user-group How Can We Do It?
If We Need To Restrict Certain Rows From Appearing To A User/user-group How Can We Do It?
How Do We Prevent A Cross-join?
What Leads To A Cross-join Or How Does A Cross-join Occur?
When Do We Need To Create A View Or A Materialized View In A Database?
What Kind Of Optimizations You Did?
How Can Users Design Dashboards Quickly And Without Programming Experience Or Training?