[SQL] What is faster?

Hi All! What is faster - SLECTion data from one large table (200 000 - 300 000 records), or SELECTion from a few small tables (example, 2 tables 150 000 records each)? Thank You ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] What is faster?

Hi All! >> What is faster - SLECTion data from one large table (200 000 - 300 000 >> records), or SELECTion from a few small tables (example, 2 tables 150 >> 000 records each)? RH> It depends. Are you selecting all records? One record? A few records? If RH> one or a few, do you have a suitable in

Re: [SQL] What is faster?

RH> ON.KG wrote: >> Hi All! >> >>>>What is faster - SLECTion data from one large table (200 000 - 300 000 >>>>records), or SELECTion from a few small tables (example, 2 tables 150 >>>>000 records each)? >> >> For example i have t