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 | Mar 28 to Apr 12 | |
SQL Server Training | Apr 01 to Apr 16 | |
SQL Server Training | Apr 04 to Apr 19 | |
SQL Server Training | Apr 08 to Apr 23 |
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