Question

I have a table "X" and it has no indexes. However it is
fragmented (dbcc showcontig X). I want to defrag the table
but when i do dbcc dbreindex it doesnt do anything. Stays
the same way. I am experiencing the same problem on
various tables. Can anyone help me please?Do you have a primary key ?
If so look up the command DBCC INDEXDEFRAG.
J
>--Original Message--
>I have a table "X" and it has no indexes. However it is
>fragmented (dbcc showcontig X). I want to defrag the
table
>but when i do dbcc dbreindex it doesnt do anything. Stays
>the same way. I am experiencing the same problem on
>various tables. Can anyone help me please?
>.
>|||Table X does not have a primary key... :(
>--Original Message--
>Do you have a primary key ?
>If so look up the command DBCC INDEXDEFRAG.
>J
>>--Original Message--
>>I have a table "X" and it has no indexes. However it is
>>fragmented (dbcc showcontig X). I want to defrag the
>table
>>but when i do dbcc dbreindex it doesnt do anything.
Stays
>>the same way. I am experiencing the same problem on
>>various tables. Can anyone help me please?
>>.
>.
>|||Although your table probably should have a clustered and some non-clustered
indexes, ( that is another conversation.)
You might simply create a clustered index on the table, then drop it... The
table rows will be cleaned up during the create index.
--
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
":)" <anonymous@.discussions.microsoft.com> wrote in message
news:050901c3de70$8682d350$a301280a@.phx.gbl...
> I have a table "X" and it has no indexes. However it is
> fragmented (dbcc showcontig X). I want to defrag the table
> but when i do dbcc dbreindex it doesnt do anything. Stays
> the same way. I am experiencing the same problem on
> various tables. Can anyone help me please?|||Hello,
The problem here then is that it can't be ordered. The
reason is that for the defragmentation to work it needs to
know what criteria it needs to do to perform the defrag.
In this case indexes.
On a peronal note can I ask why no indexes ?, that makes
for a very slow database.
J
>--Original Message--
>Table X does not have a primary key... :(
>>--Original Message--
>>Do you have a primary key ?
>>If so look up the command DBCC INDEXDEFRAG.
>>J
>>--Original Message--
>>I have a table "X" and it has no indexes. However it is
>>fragmented (dbcc showcontig X). I want to defrag the
>>table
>>but when i do dbcc dbreindex it doesnt do anything.
>Stays
>>the same way. I am experiencing the same problem on
>>various tables. Can anyone help me please?
>>.
>>.
>.
>