in reply to Query takes 895ms in TOAD but 42s in DBI

Perhaps you are running the same thing in the two environments, but as different users, and one user does not have permission to use an index?
  • Comment on Re: Query takes 895ms in TOAD but 42s in DBI