INDEX NAMES

• gazzer

  SSC Eights!

  Points: 885

  More actions

  January 25, 2006 at 6:44 am

  #111728

  Hi, this maybe a silly question, but I have noticed in one or two of our users table and Index that I do not seem to be able to DEFRAG.

  For example we have a tbale with three indexes in it.

  INDEX_A

  INDEX_B

  tINDEX_C

  I don't seem to be able to defrag the tINDEX_C, is there a simple explanation for this, and what does the 't' indicate.

  Sorry for this nooby question, but that is what I am.

  Cheers

• Giles McArdell

  SSC Eights!

  Points: 845

  More actions

  January 26, 2006 at 4:17 am

  #617103

  I think we need more info, when you say 'I don't seem to be able to defrag the tINDEX_C' what happens when you try? What error message do you get?

  The 't' looks like a typo - for instance someone changing the Server assigned default name to the required name mis-positioned the cursor.

   

  ---

  "Don`t try to engage my enthusiasm, I don`t have one."

  (Marvin)