0

Hi,
I've imported a Visual FoxPro database to MS SQL Server 2008 and had a couple of queries;
The VFP tables used Numeric(5,0) for the Index fields, but I'm thinking of converting them to Integers in SQL Server. Is there any issues I should be aware of? A co-worker keeps telling me that Integers are "slower" to search on, which I find a bit hard to believe. I always thought that you would you use Numerics for data that requires precision, such as financial data and Integers for counters whole number id's and so on. Am I wrong or missing something?

Thanks

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by sknake
0

>>A co-worker keeps telling me that Integers are "slower" to search on, which I find a bit hard to believe
He's an idiot.

Integers are fine. Just be sure to index your database properly -- and this is regardless of datatype (string, integer, decimal, etc).

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.