1.

List Advantages Of Column-based Tables.?

Answer»

• ALLOWS smoother PARALLEL processing of data as the data in columns is stored vertically. Thus, to access data from multiple columns, every operation can be allocated to a separate processor core.
• Only specific columns need to be approached for SELECT query and any column can be used for indexing.
• Efficient operations since most columns hold UNIQUE VALUES and thus, high compression rate.

• Allows smoother parallel processing of data as the data in columns is stored vertically. Thus, to access data from multiple columns, every operation can be allocated to a separate processor core.
• Only specific columns need to be approached for Select query and any column can be used for indexing.
• Efficient operations since most columns hold unique values and thus, high compression rate.


Discussion

No Comment Found

Related InterviewSolutions