Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 MOD-Group
 MOD Add-On Forum (W/Code)
 More on indexes		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

grazman
Junior Member

USA
193 Posts
Posted - 09 September 2000 :  11:59:59  Show Profile  Visit grazman's Homepage
It appears that the index FORUM_CAT_ID on FORUM(CAT_ID) and FORUM_F_CAT on FORUM(CAT_ID) are identical. Can we remove one?

It appears that MODERATOR(MEMBER_ID) has two identical indexes on it: MEMBFORUM_MODERATOR and MODERATORS_MEMBER_ID

The TOTALS table appears to have an index on it. If this table really has one row can we remove the index?

<font color=blue><b>SQLTeam.com</font id=blue></b> - For SQL Server Developers and Administrators

gor
Retired Admin

Netherlands
5511 Posts
Posted - 30 September 2000 :  06:47:16  Show Profile  Visit gor's Homepage
changed in beta 5

<b>Pierre Gorissen</b>

<font color=blue><font size=1>Experience is that marvelous thing
that enables you to recognize a mistake when you make it again.
</font id=blue></font id=size1><font size=1><font color=black>F.P.Jones</font id=size1></font id=black>
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.31 seconds. Powered By: Snitz Forums 2000 Version 3.4.07