If you have a database with 200 fields and another with 5 fields. The both have the same nos of rows. If you are searching for the same perameters will it return results as quickly for the table with more fields as the one with less. i.e. does the number of fields effect speed in the same way nos of rows does?
2007-01-10 09:26:31 · 1 answers · asked by jonnie b 1 in Computers & Internet ➔ Programming & Design
The question is a bit too broad to answer authoritatively. How quick a search takes place has more to do with using proper keys and data types than it does how many columns the table contains.
All things otherwise equal, if table A and table B have the same data types and data in a column that is being searched, there's no difference in transaction speed. That is, they would both execute the following statement in the same amount of time:
SELECT column
FROM table
WHERE column LIKE '%value%'
2007-01-10 12:39:30 · answer #1 · answered by Anonymous · 0⤊ 0⤋