Reindex systems tables

Hi All
Just want to know, How can we reindex systems table? i.e
syscolumns, sysdepends, sysusers etc.
In case it can be done automatically, How can we let it
reindex by itself?
The problem is sp_help_fulltext_columns issue in nearly
the same database but generate totally different execution
plan. One execute for 1.23 minutes and another for 0.01
minutes.
I still think about the systems table because it use
only systems table concern, may be I wrong. Any recommend
will be very appreciate.
Thanks you in advance.
James Jarupan
How do the execution plans differ?
Do the system tables have the same number of rows in? Differening numbers of
rows can generate different execution plans.
Hilary Cotter
Looking for a book on SQL Server replication?
http://www.nwsu.com/0974973602.html
"James Jarupan" <anonymous@.discussions.microsoft.com> wrote in message
news:9b7001c478cb$82022790$a301280a@.phx.gbl...
> Hi All
> Just want to know, How can we reindex systems table? i.e
> syscolumns, sysdepends, sysusers etc.
> In case it can be done automatically, How can we let it
> reindex by itself?
> The problem is sp_help_fulltext_columns issue in nearly
> the same database but generate totally different execution
> plan. One execute for 1.23 minutes and another for 0.01
> minutes.
> I still think about the systems table because it use
> only systems table concern, may be I wrong. Any recommend
> will be very appreciate.
> Thanks you in advance.
> James Jarupan
|||Something strange with this Stored Procedure,
sp_help_fulltext_columns. I test with different databases
in different computers it show the same execution plan.
The reason may be this stored procedure is in Master
Database.
So the rows in system tables should not have the effect
but I will check all again.
Can you provide the second point that I should pay
attention.
Thanks you.
James Jarupan

>--Original Message--
>How do the execution plans differ?
>Do the system tables have the same number of rows in?
Differening numbers of
>rows can generate different execution plans.
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"James Jarupan" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:9b7001c478cb$82022790$a301280a@.phx.gbl...
i.e[vbcol=seagreen]
it[vbcol=seagreen]
nearly[vbcol=seagreen]
execution[vbcol=seagreen]
recommend
>
>.
>
|||Something strange with this Stored Procedure,
sp_help_fulltext_columns. I test with different databases
in different computers it show the same execution plan.
The reason may be this stored procedure is in Master
Database.
So the rows in system tables should not have the effect
but I will check all again.
Can you provide the second point that I should pay
attention.
Thanks you.
James Jarupan

>--Original Message--
>How do the execution plans differ?
>Do the system tables have the same number of rows in?
Differening numbers of
>rows can generate different execution plans.
>--
>Hilary Cotter
>Looking for a book on SQL Server replication?
>http://www.nwsu.com/0974973602.html
>
>"James Jarupan" <anonymous@.discussions.microsoft.com>
wrote in message[vbcol=seagreen]
>news:9b7001c478cb$82022790$a301280a@.phx.gbl...
i.e[vbcol=seagreen]
it[vbcol=seagreen]
nearly[vbcol=seagreen]
execution[vbcol=seagreen]
recommend
>
>.
>