Introduction
Step 1:- Creating a cluster
Step 2:- Create an index on cluster.
Step 3:- Create cluster table.
Create a cluster based on a common column name, this common column name is also called as key.
Syntax –
Create cluster clustername (common column name data type (size))
Syntax –
Create index indexname on cluster clustername;
Frequently Asked SQL Server Interview Questions
Syntax –
Create table tablename (common colname datatype (size), col1 datatype (size),…..)
Cluster clustername (common col name);
SQL > create cluster emp_dept (deptno number (10));
SQL > create index abc on cluster emp_dept;
SQL > create table emp1 (empro number (10), ename varchar 2 (10) sal number (10), deptno number (10)), cluster emp_dept (deptno);
SQL > create table dept1 (deptno number (10), dname varchar 2(10), loc varchar2 (10)) cluster emp_dept (deptno);
SQL > desc emp1;
SQL > desc dept1:
Note:-
Syntax –
Drop cluster clustername including tables;
Ex:- SQL > drop cluster emp_dept:
Error: cluster not empty
SQL > drop cluster emp_dept including tables;
O/P:- Cluster dropped.
In oracle all information of cluster stored under user_clusters
data dictionary
SSRS | Power BI |
SSAS | SQL Server |
SCCM | SQL Server DBA |
SharePoint | BizTalk Server |
Team Foundation Server | BizTalk Server Administrator |
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
SQL Server Training | Sep 30 to Oct 15 | View Details |
SQL Server Training | Oct 03 to Oct 18 | View Details |
SQL Server Training | Oct 07 to Oct 22 | View Details |
SQL Server Training | Oct 10 to Oct 25 | View Details |
Arogyalokesh is a Technical Content Writer and manages content creation on various IT platforms at Mindmajix. He is dedicated to creating useful and engaging content on Salesforce, Blockchain, Docker, SQL Server, Tangle, Jira, and few other technologies. Get in touch with him on LinkedIn and Twitter.
Copyright © 2013 - 2023 MindMajix Technologies