Optimizing Queries, Views vs Tables

From: James Alexander Starritt <james_at_jamesstarritt.com>
Date: Thu, 7 Feb 2002 11:49:20 -0600
Message-ID: <a3ueur$1bgi8r$1@ID-68406.news.dfncis.de>

Guys,

I'm going to be starting creation of some training materials soon and would like to know if there are any resources on-line the explain how to optimizie queries - yunno standard stuff like what selections to run first. I would also like to know if there is any text out there explaining how and why and views are slow -- I know the answers but I tend to not dumb stuff down enough sometimes and would like a basic outline to start working from.

Any ideas ?

James Received on Thu Feb 07 2002 - 11:49:20 CST

Optimizing Queries, Views vs Tables - Info Needed