Data Warehousing Question: Download Questions PDF
How many clustered indexes can u create for a table in DWH? In case of truncate and delete command what happens to table, which has unique id.
Answer:
You can have only one clustered index per table. If you use delete command, you can rollback... it fills your redo log files.
If you do not want records, you may use truncate command, which will be faster and does not fill your redo log file.
If you do not want records, you may use truncate command, which will be faster and does not fill your redo log file.
Download Data Warehousing Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is loop in Data warehousing? | What is hybrid slowly changing dimension? |