Re: does the number of column affect performance

2012-03-08 Thread Zheng Li
sorry for the duplicate message. just ignore it. On 2012/03/09, at 10:11, Zheng Li wrote: > > what if I have to select all columns every time? > any difference in performance? > > On 2012/02/29, at 4:41, Paul DuBois wrote: > >> >> On Feb 28, 2012, at 9:59 A

Re: does the number of column affect performance

2012-03-08 Thread Zheng Li
what if I have to select all columns every time? any difference in performance? On 2012/02/29, at 4:41, Paul DuBois wrote: > > On Feb 28, 2012, at 9:59 AM, Zheng Li wrote: > >> for example >> there are 2 tables to save same data >> table A has 10 columns: a pr

Re: does the number of column affect performance

2012-02-28 Thread Zheng Li
even if I select all columns every time no matter it is Table A or B, A has better performance? On 2012/02/29, at 4:41, Paul DuBois wrote: > > On Feb 28, 2012, at 9:59 AM, Zheng Li wrote: > >> for example >> there are 2 tables to save same data >> table A has 10 co