Indexes and more Table Creation

10/12/1999


Click here to start


Table of Contents

Indexes and more Table Creation

Indexes

Creating an Index

Composite Index

2 Kinds of Indexes

Unique Index

Clustered Index

Things to Consider

What Should We Index?

We Should NOT Index…

SQL-92 Create Table Constraints

Put it on paper!

Then write your SQL

Changing a Table

Removing Objects

Joins

2 ways of looking at a Join

 Author: John T. Laker

Email: jlaker@udel.edu

Home Page: http://www.udel.edu/jlaker/sql99f/

Download presentation source