SQL:VIEW

VIEW is like a virtual table that can retrieve the actual table as defined in the creation of VIEW(the actual SQL query and VIEW will be defined together)

 Create VIEW class_list(stno, name, birthdate) AS

 SELECT stno, name, dob FROM

 Student courseid = 'cosc2222' or courseid = 'cosc2223';

****************************************************************************************************

Select stno,name,birthdate

FROM class_list

ORDER by name;

(You can view by select * from class_list)

SYNONYM is an alias for another schema object, for example: tables,views

This can be good for security and convenience,

it masks the object's name and owner's name

CREATE PUBLIC SYNONYM sales

     FOR  student1.sales_data;

*******************************************

SELECT * FROM sales;

(We have make sales reference to student's table "sales_data"

so we can use select * from sales ,this would actually display select * from sale_data；）

INDEXES

We can create indexes for a table as long as the columns differs for each index.

We can also create more than one index using then same column.

(the columns must be in different combinations)

CREATE INDEX student_index1 ON

                  students(last_name, id)

********************************************

CREATE INDEX student_index2 ON

                students(id,last_name)  

(id,lastname)   &  (lastname, id )

THESE ARE DIFFERENT COMBINATIONS