Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003
    Location
    Pinoy in NJ
    Posts
    104

    Unanswered: Corrupt Index Cannot Find Customer

    Would a corrupt index on a column (i.e. CustomerNo, Integer) would not make me get a hit on a query? I get a hit using FirstName or LastName but not on a CustomerNo. I'm thinking that I should still find the record but would take a longer time. I have no access on the DB and relying on the tech support who stated that a corrupt index was the issue.

    TIA

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    A corrupt index is one possible explanation for the behavior that you are reporting. I don't know of any way to be sure based solely on the information that you've provided.

    -PatP
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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