Technology Questions by Viewers and Answers by WisdomAxis Team.
(Posted by viewer on July 27th, 2018)
Answer posted on August 31st, 2018
Blockchain (or) Block chain
Technically blockchain is one variety of multinode data processing technique, specifically using inter-node communication technique.
Blockchain data records are not unalterable, but considerd secured by design.
... Click here for full details
Why only one clustered index for a table?
(Posted by viewer on April 3rd, 2018)
Answer posted on April 6th, 2018
Clustering Index determines how rows are physically ordered in a table. It is a best practice to sort the table based on key values then create a clustered index. The cluster index is created based on the physical order of the records in the table and we can have only one physical order of the records in the table at any given point of time, so we can create only one clustered index per table.
Clustering index helps to improve the performance in some specific operations such as grouping, ordering and comparison other than the equal condition in where clause.