Doubt in Select Query

[Former Member]

Hi,

I want to get data from 2 table which query is effeicient one

by seeing performance...

1. using for all entries statement

2. Get data using join query.

Thanks in advance

[Former Member]

Hi,

For all entries is better than koin conditions.

[Former Member]

Hi John,

FOR ALL ENTRIES is the best one when performance is considered.

Regards,

Chandra Sekhar

[Former Member]

Always For all entries is better.

With luck,

Pritam.

[Former Member]

Hi,

It would better to use over using join with multiple pages...

From which tables you are fetching data.

Regards,

Amit

[Former Member]

FOR ALL ENTRIES is better for some reasons,

--> If the data is huge , then some times JOIN may end up in TIME OUT error

--> FOR ALL ENTRIES will use the INDEXEs of the tables and improves the performance