Explain the significance of cluster table or non cluster table.A Cluster provides an alternate method of storing table data. It is made up of a group of tables that share the same data i.e. same columns and thus are often used together. Primary benefits of this approach are:
- Disk I/O is reduced and access time improves for joins related to clustered tables.
- Cluster key is the common column/s among the table which reduces storage needs.
Non cluster tables must be used if individual tables are used/accessed frequently.