Tables Views Indexes 

Tables

Tables, as we know are a collection of related rows and columns describing some business processing entity such as a department, an employ a project or a purchase order etc.

To learn how to create table in SQL Click here

View

A View is a logical sub set of a table. To a user, a view will look just like a table. But they are only images or descriptions of a table and do not store any physical data. Views can contain some or all of the columns of a table.

Indexes

Indexes are pointers to specific rows in a table. They are logically ordered by the value of a key. For example an index created on emp_code will store all the employees code numbers along with a pointer to the corresponding row, in a table. Data retrieval becomes fast when indexes are used. It is often good idea to index one or two key columns of every table. Indexes cannot be referenced in SQL statements.