View: View: is Nothing but it is a virtual table .you can access data fast,
Indexes: Indexes is Nothing but retrive the data from one or more tables and Arrange the B-Treee Structure that is called Indexes.
Indexes are two types:
1)Clustred Indexes:Clusred indexes is created based on the Primarykey.Default primarykey
2)Non-Clustred Indexes:It cab created based on Uniqkey
Trigger:trigger is Automatically excuted when ever event occure.
Function:Function is must return a value.In Function you can pass only input Parameters