Creation of index on Varchar column

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • gangadhar NG
    New Member
    • Jul 2012
    • 3
    #1

    Creation of index on Varchar column

    If i create an index on Varchar column, It improves the query performance? Yes or No.Explain

    Thanks in advance
    Tags: None
    • Niheel
      Recognized Expert Moderator Top Contributor
      • Jul 2005
      • 2432
      #2
      Ideally, it would be better to use a numeric value, but if you were to crate an index on a varchar, make sure it's not a big varchar and make sure you have plenty of memory. Indexing varchar columns will create big index files.
      niheel @ bytes

        Comment

        • ck9663
          Recognized Expert Specialist
          • Jun 2007
          • 2878
          #3
          It sounds like an assignment, though...

            Comment

            Previous template Next
            Working...