By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,946 Members | 1,610 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,946 IT Pros & Developers. It's quick & easy.

Creation of index on Varchar column

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

Thanks in advance
Jul 12 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 100+
P: 2,330
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.
Jul 12 '12 #2

Expert 2.5K+
P: 2,878
It sounds like an assignment, though...
Jul 12 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.