Tag Archives: index

In WordPress 2.5.1 – finding the missing comments in the admin -> show all comments

If you have comments in your WordPress 2.5.1 blog but the admin page says you don’t:

Then you probably have a missing index on the table wp_comments.  You just need to add an index on column comments_date_gmt:

Share Button

Finding suspect indexes in Sybase ASE

Problem: ASE does not use an index on a table because it is marked suspect

Index id 2 on table id 864003078 cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table.
Index id 2 on table id 864003078 cannot be used in the optimization of a query as it is SUSPECT. Please have the SA run DBCC REINDEX on the specified table.
Index id 2 cannot be used to access table id 864003078 as it is SUSPECT. Please have the SA run the DBCC REINDEX command on the specified table.

Solution:  Use sp_indsuspect to identify the suspect indexes in a database and run dbcc reindex(<tablename>) tables.

dbcc reindex can only be executed on a single table at a time in a database so if time is short, you may be better off dropping and creating the indexes in parallel.

Share Button