What are the approaches used by optimizer during execution plan?

Question Posted / vikram kapoor

No Answer is Posted For this Question
Be the First to Post Answer

More Data Warehouse General Interview Questions

"A dimension table is wide but the fact table is deep," explain the statement in your own words.

How can you set the session management?

What is drill-through?

Suppose we want to display zero when null values coming to report how can we do that?

Explain what are the methodologies of data warehousing?

What are the tools available for etl?

What is the goal of optimizer?

Explain the difference between keylokup and joiner?

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

What is surrogate key? Explain with examples.

Explain what is a view as it relates to system modeling?

what is Materialized Views?

For more Data Warehouse General Interview Questions Click Here