Indexes

From: skc (anonymous_at_discussions.microsoft.com)
Date: 03/16/04 

Date: Tue, 16 Mar 2004 02:18:22 -0800

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: [PHP] People who bought this also bought (amazon style) functionality...logic problem
    ... joins users with products that they have bought. ... Looks like I will really have to brush up on my Sql, ... Do You Yahoo!? ... Mail has the best spam protection around ...
    (php.general)
  • Re: Ask for a query
    ... I want a query that let ... Customer_ID 1 bought for the first time in September 2003, ... How do I write that in SQL? ... MON CUSTID ...
    (comp.databases.oracle.server)
  • Re: Indexes
    ... Answered in .mseq and .server ... "skc" wrote in message ... > I am new to SQL 2000. ... We have bought the full version and ...
    (microsoft.public.sqlserver.tools)
  • Re: Merging two sql databases
    ... is to insert data from sql I bought into sql which came ... ALTER TABLE table_name RENAME normal_database_name.table_name ... Do you mean that I supposed to install a database I bought than work on that? ...
    (alt.php)
  • Re: Merging two sql databases
    ... is to insert data from sql I bought into sql which came ... with a website's script. ... It is MySql database. ...
    (alt.php)