difference between clustered and non-clustered classification. which is better performance wise. what will you do in both cases, in case database is out of storage

Question

Accepted Answer

Clustered classification organizes data based on similarity, while non-clustered does not. Performance wise, clustered is better. If database is out of storage, in clustered classification data can be moved to another node, while in non-clustered classification data can be stored in a temporary location.

Clustered classification organizes data into groups based on similarity, improving query performance.
Non-clustered classification does not organize data based on similarity, leading to slower query performance.
In case the database is out of storage, in clustered classification data can be moved to another node to free up space.
In non-clustered classification, data can be stored in a temporary location until more storage is available.

difference between clustered and non-clustered classification. which is better performance wise. what will you do in both cases, in case database is out of storage

Top A P MOLLER MAERSK GROUP TERMINALS Intern interview questions & answers

Popular interview questions of Intern