Indexing and Joins

03/09/2000


Click here to start


Table of Contents

Indexing and Joins

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

Joins

What to join?

Syntax

Self Join

How a Join is Processed

2 ways of looking at a Join

 Author: John T. Laker

Email: jlaker@udel.edu

Home Page: http://www.udel.edu/jlaker/sql-00s/

Download presentation source