To comprehend the difference between the two types of joins i.e. inner join and Outer join in SQL, let’s first revise the basic knowledge about the join in SQL, the inner join and the outer join. What is a join in SQL? A join in SQL may be defined as a way which is used […]
Archives for December 2015
SQL: Clustered vs non clustered Index
An index in SQL may be defined as a structure linked with a particular table and is stored on the disk, mainly created to enhance the speed of the retrieval of data. The key for an index in SQL is created from one or more than one column present in a particular table or even […]
SQL questions: What is an index?
An Index in SQL may be defined as the secondary database object which is connected to a specific table to enhance the process of retrieval of the associated rows from that particular table. It can be defined for a specific single column or for multiple columns. We can also view an index of SQL as […]
SQL - Difference between Primary and Foreign Key
To understand the difference between PRIMARY KEY and FOREIGN KEY in SQL, you first need to understand the definition of a PRIMARY KEY as well as a FOREIGN KEY. SO, Read: More Interview Questions PRIMARY KEY: It can be defined as a unique column or a group of few columns which are chosen to identify […]