Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
satish.gorijala
Posting Yak Master
182 Posts |
 Posted - 2009-05-15 : 05:32:36
|
| Hi, i have one excel file with column name as zipcode containing data.i have one database table containing data zipcode column .I am reading data of zipcode col from excel and matching with zipcode col of database. Here i observe one thing. If the zipcode contains hypen(94122-2229) the query is taking more time. If the zipcode is normal one(94122) it is faster. The zipcode col in database contains clustered index.Is there any effect in query while comparing direct data or hypen data?Excel DataZipcode94122-2229967899876-03459876-987893342Database dataZipcod97657087659876-2229345679876-9878G. Satish |
|
|
pootle_flump
1064 Posts |
Posted - 2009-05-15 : 07:39:41
|
| What is your query? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-15 : 13:25:55
|
| does execution plan show any difference? |
|
|
|
|
|
|
problem with hypen ?