Yes. Duplicate indexes are not needed.
-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 29, 2002 5:55 PM
To: CF-Talk
Subject: OT: SQL Server Indexes
Hi all. I've noticed when upsizing an Access database, I'll get
duplicate indexes on the primary
Bud,
It depends on if the category_id is a field that is searched alot. If that is
the case, you might as well leave that index as it will help performance. If
not, then deleting it will harm nothing...
Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: Bud [EMAIL
Never mind...I was not thinking, just delete it.
Douglas Brown
Email: [EMAIL PROTECTED]
- Original Message -
From: Bud [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Saturday, June 29, 2002 4:54 PM
Subject: OT: SQL Server Indexes
Hi all. I've noticed when upsizing an Access
from the BoL:
Note
System tables should not be altered directly by any user. For example,
do not attempt to modify system tables with DELETE, UPDATE, or
INSERT statements, or user-defined triggers.
But I only want to INDEX one - that's not altering the system (if it's not a
clustered index)
Although the system catalogs can be referred to in SQL
statements as if they were normal tables, they aren't
necessarily stored or managed in the same way as normal
tables internally by the DBMS. So a command like CREATE
INDEX quite possibly wouldn't work even if it was allowed.
Damn, I'd
ge-
From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
Sent: 02 February 2001 11:21
To: CF-Talk
Subject: RE: SQL Server Indexes and System Objects
But I only want to INDEX one - that's not altering the system (if it's not
a
clustered index)
Philip,
Although the system catalogs can be referred
I too have wondered how one can alter system tables - what I wanted to do was
add a trigger to the system tables to audit changes to the database structure...
however I was not able to, even though I was using the sa login.
David Cummins
Philip Arnold - ASP wrote:
This might be a dumb
I too have wondered how one can alter system tables - what I wanted to do
was
add a trigger to the system tables to audit changes to the database
structure...
however I was not able to, even though I was using the sa login.
monkeying about with your system tables is a disaster waiting to
Obviously its potentially dangerous - but I don't like the MS policy of taking
your toys away because somebody else wasn't playing nice with them.
So as far as you're aware, its not possible? Not even to add triggers etc?
David Cummins
Paul Hastings wrote:
I too have wondered how one can
Thanks Paul - at least I know to give up now!
I just figured it would be nice to do change control on the database
definitions, because obviously things can get nasty if they get out of sync with
your production server.
Heard anything that might help in that regard?
David Cummins
Paul
10 matches
Mail list logo