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 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