We can create only one cluster index per table in SQL Server.
Kindly do not put wrong answers.
Kindly do remove answer of web control and user control under this thread.
Loading
We can create only one cluster index per table in SQL Server.
Kindly do not put wrong answers.
Kindly do remove answer of web control and user control under this thread.
1.If you have a primary in a table then only one cluster index is created. by default index is cluster.
2.When you don't have primary key in the table then we can create more that one cluster index.
Custom Control:- 1. You create a Custom control when it is going to be used across different applications
2. Custom controls don't a visual interface.
3. Custom controls however can be added to your tool box and used in different applications without re-compiling.
4. It's a .dll.
It is global to all the pages.Apper in toolbox,its a precomplied code.
User Control:- 1. If the control you are going to create is only for a particular website then User Control is the best option
2. User controls have a visual interface
3. User control will not appear in tool box and it will not have design support and loaded at runtime.
4. It's an .ascx
It support cacheing.It will be complied dynamically along with webpage.