Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003
    Location
    India
    Posts
    114

    Unanswered: Index and analyze

    Whenever we have a index on the table , we should analyze our table.

    Is this true ? Should this be done even when the rows in table are less than say 3500.

    Any pointers will be helpful.

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    No, you should always analyze all your tables, whether indexed or not. The fact that the table has only say 10 rows might be very significant for the optimizer!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •