Re: Indexes

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 05:31:20 -0500

I would read on these in BOL first, then take a look at this page -
http://www.sql-server-performance.com/gv_index_data_structures.asp , Then if
you still have questions, come back.

HTH 

-- 
Ray Higdon MCSE, MCDBA, CCNA
---
"skc" <anonymous@discussions.microsoft.com> wrote in message
news:b02001c40b40$030072b0$a601280a@phx.gbl...
> Hi,
>
> I am new to SQL 2000.  We have bought the full version and
> we have created some tables with large numbers of records
> (20m, 60m etc...) but I wish to know more about Indexes
> and all the different types within SQL 2000 and which one
> to use and for what.
>
> Clustered and Non-clustered needs to be explained in laman
> terms please.
>
> Thanks,
>
> Skc

Relevant Pages

  • Re: field alias when running SQL on sheet ranges
    ... E.TERM_TEXT AS FIELDALIAS ... > How would you do the same in range SQL? ... >> HTH ... >> (remove nothere from the email address if mailing direct) ...
    (microsoft.public.excel.programming)
  • Re: Deleting a Record.
    ... >> Have a look at www.mysql.com for sql syntax ... >> HTH, Jochen ... >> database editing interfaces. ... PHP DB Edit Toolkit -- PHP scripts for building ...
    (comp.lang.php)
  • Re: BDE vs ADO
    ... I know MS SQL is pricey - but I think it is worth the money. ... "Rohit Dhamija" wrote in message ... > barry clark wrote: ... >> HTH ...
    (borland.public.delphi.database.ado)
  • RE: Opening a MS Access APP - if the SQL connection is not found.
    ... >> 'clean up the sql connection variables ... >> HTH, ... >> Phillip Williams ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: get a value from as we loop through table
    ... You could either filter out nulls using SQL in your data source, ... SusanV ...
    (microsoft.public.access.formscoding)