Re: Table Row count: Limiting factor

2008-07-22 Thread madhav
Thanks Malcolm and my apologies for posting it here. On Jul 21, 11:49 pm, Malcolm Tredinnick <[EMAIL PROTECTED]> wrote: > On Mon, 2008-07-21 at 08:13 -0700,madhavwrote: > > Hello guys, I am just confused with a fundamental db problem. I have > > table which has got 48 lakh rows(each row has got

Re: Table Row count: Limiting factor

2008-07-21 Thread Malcolm Tredinnick
On Mon, 2008-07-21 at 08:13 -0700, madhav wrote: > Hello guys, I am just confused with a fundamental db problem. I have > table which has got 48 lakh rows(each row has got 8 fields, all > INDEXED) and I just need to fetch 500 rows from it. Would that take > more time than extracting the same