Interested to Buy Any Domain ? << Click Here >> for more details...
What is clustered and non-clustered indexes?
- 4 Answers
- 13889 Views
- Microsoft, I also Faced
- E-Mail Answers
Answer Posted / ganesh sial
both index are stored physically but cluster index is create block of key value which more helps to like join,hash condition,more reliable to parent child relation ship
ex:- deptno is primary key for dept table, its create cluster index,
when write query of join like
select a.empno,a.deptno,b.loc from emp a,dept b where a.deptno=b.deptno
this case the cluster index helps to better perfomance
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Can we use distinct and group by together?
What is the command used to fetch first 5 characters of the string?
What is normalization sql?
Explain the difference between 'between' & 'and' operators in sql
Explain the order of sql statement execution?
What is a data manipulation language?
C. Normalize the following data up to the 3rd Normal form. Create the tables and insert the data given. Emp_ID Name Dept_Name Salary Course_Title Date_Completed 100 Adam Marketing 48,000 SPSS 6/19/2008 Surveys 10/7/2008 140 Bob Accounting 52,000 Tax Acc 12/8/2008 110 Cathy IT SQL Server 1/12/2008 C# 4/22/2008 190 Dan Finance 150 Emily Marketing 55,000 SPSS 6/16/2008 42,000 Analysis 8/12/2008 Queries 1. Find all Names who have completed the SPSS Course. 2. Find employee with max salary. 3. Find employee with 2nd max salary. 4. Find all employees in Dept “Marketing”. 5. Find all the employees who have taken more than 2 courses. 6. Find all the employees who have completed the courses before month of September.
Define concurrency control. : Transact sql
What is the unique index?
Write an sql query to select all records from the table?
Which one is faster ienumerable or iqueryable?
how to rename an existing column in a table? : Sql dba
How can I get the number of records affected by a stored procedure?
What is cross join example?
What is user in sql?
