Clustered Indexes / Primary Key
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
Hi All,
I am converting an Access app. from .mdb to ODBC link to a SQL Server.
The first thing I have run into is Clustered Indexes not sorted. I have a
small lookup table with 2 fields. From what I was told here by our DBA,
every key has to have a primary key/clustered index. So, the lookup tables
first field is nothing but Category Numbers which are unique and created by
the user. The table has 121 records. The 2nd field is the Category Name.
The Cat. No. is the Primary Key, Clustered, Unique, No-Nulls. The Cat. Name
is indexed non-clustered. When you open the table, it is sorted by the Cat.
Name and not by the Primary Key! Why????
This is not the behavior I'm looking for. Just learning SQL Server.
Don
.
Relevant Pages
- Re: Primary Key indexing
... I almost never cluster on PK because often my biggest priority is selecting ... Clustered indexes are great for selecting large numbers of rows, ... clustered index on the Primary key, or any other strictly ascending key and ... I support the Professional Association of SQL Server and it's community of SQL Server professionals. ...
(microsoft.public.sqlserver.programming) - Re: Clustered Index question
... Columnist, SQL Server Professional ... If I keep the primary key, ... >select packet_time,packet_data from packet where ... >have the clustered index (either on PACKET_TIME or on ...
(microsoft.public.sqlserver.programming) - A pk is *both* a physical and a logical object.
... Primary key is a logical constraint. ... but SQL Server does not allow you to create a unique or primary ... constraints) by indexing is purely *platform dependent*. ... PKs are part of the ANSI SQL standard *for db implementations*. ...
(comp.databases.theory) - Re: Re-Seed in SQL Server
... Add a new field to the table that holds the Primary Key. ... or something like that and make it an Autonumber field and a Primary Key. ... If the table is already on the SQL Server you could try the below. ... that your Autonumber field in the Access Database has gotten corrupted. ...
(microsoft.public.access.tablesdbdesign) - Re: Clustered Index question
... Columnist, SQL Server Professional ... Without having primary key in the table, will it slow down the query that I ... the clustered index on PACKET_TIME, and instead have a clustered index on ...
(microsoft.public.sqlserver.programming) |
|
