topic Re: Doubt in Select Query in Application Development and Automation Discussions

Doubt in Select Query

Former Member — Fri, 01 Aug 2008 09:54:18 GMT

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 — Fri, 01 Aug 2008 09:55:13 GMT

Hi,

For all entries is better than koin conditions.

Former Member — Fri, 01 Aug 2008 09:55:41 GMT

Hi John,

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

Regards,

Chandra Sekhar

Former Member — Fri, 01 Aug 2008 09:56:18 GMT

Always For all entries is better.

With luck,

Pritam.

Former Member — Fri, 01 Aug 2008 09:57:09 GMT

Hi,

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

From which tables you are fetching data.

Regards,

Amit

Former Member — Fri, 01 Aug 2008 09:59:31 GMT

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