c532e184-4de1-4de1-a871-9ca58bdeb9f7

Exercises:

1. Delete the type data from table T1, create appropriate indexes on T1 and T2 and repeat the update operation - do you notice anything about the speed?

update T1 set type = null;

create index id_index on T1(id);

create index id_index on T2(id);

update T1 inner join T2 on T1.id = T2.id where T1.type = T2.type;

2. Create a view on T1 for each of the types

create view rrview on T1 as select * from T1 where type = "RR";

create view ebview on T1 as select * from T1 where type = "EB";

create view ceview on T1 as select * from T1 where type = "CE";

3. Create a stored procedure to return the counts for objects of a particular type between skew and kurtosis bounds.

Ay 119

Lecture 5: Intro to SQL - II

Updated Apr 19, 2012 at 10:36 AM by M Graham

Document Info Close

‣ Tags

No tags

‣ Related

No related items

‣ Comments

‣ History (5 New)