What does Sherlock Holmes think about the legend? how do you know?

In Chapter Two, we learn that Holmes considered the legend nothing more than a fairy-tale.

“Do you not find it interesting?”
“To a collector of fairy tales.”