SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Query does not return when adding a varchar field to select and group

793793Aug 25 2010 — edited Aug 25 2010

with regards to performance - I have a simple query that joins three tables on primary keys - total record count expected is 57000.
when I select and group by the primary keys - results come back within 11 seconds - which is questionable performance to start, however once I add a varchar2(250) column to the select and group - the query does not return anything (its been ten minutes since my last test).

Question - using oracle SQL developer tool 2.1.1.64 on a windows XP pro laptop connecting to an Oracle 11g environment.

All and any viable suggestions are welcome.

Best regards,

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 22 2010

Added on Aug 25 2010

4 comments

1,178 views