What is index, cluster index and nonclustered index?
- 1 Answers
- 1080 Views
- I also Faced
- E-Mail Answers
Answer Posted / Vinay Kumar Sahu
1. Index: A database object that improves the speed of data retrieval by organizing data in a specific order.
2. Clustered Index: A type of index that sorts data physically, with only one clustered index per table. It is used as the primary key.
3. Nonclustered Index: A secondary index that does not sort data physically. It can be created for multiple columns and has a separate data structure.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How efficient you are in oracle and SQL server?
What is a view in sql?
How can we solve concurrency problems?
What are different types of constraints?
What is a coalesce function?
What is temporary table in sql server? Why we use temp table?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
What are wait types?
Explain “row_number()” in sql server with an example?
What is in place upgrade in sql server?
Can sql servers link to other servers like oracle?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Where can you add custom error messages to sql server?
How can I check that whether automatic statistic update is enabled or not?
How to connect php with different port numbers?
