Running Queries from OraDeveloper for VS2k8

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
Posts: 2
Joined: Fri 10 Apr 2009 15:05

Running Queries from OraDeveloper for VS2k8

Post by leonardo.montes » Fri 10 Apr 2009 15:18

I was trying to run a very simple query from the SQL Window within the VS 2k8 IDE:

select A.indiv_id
A.subsc_cd = b.subsc_cd
AND A.indiv_id = C.indiv_id (+)
AND A.indiv_id = d.indiv_id (+)
AND rownum < 5

... and realized It was taking forever... so I went asked the Oracle guys about this... They've ran the same query using TOAD and the result came back in a flash...

... I wasn't really happy with the idea of switching back to TOAD, so I asked them to run a profile analysis on the query and found out that after my query is sent to the database, the following query is also sent:

SELECT count(*) AS record_count
FROM (SELECT a.indiv_id
FROM cnsmr_subsc_opt a, ref_subsc_cd b, cpgn_promo_hist c,
cnsmr_indiv_attrib d
WHERE a.subsc_cd = b.subsc_cd
AND a.indiv_id = c.indiv_id (+)
AND a.indiv_id = d.indiv_id (+)
AND rownum < 5) record_count_table

... and since we have a couple of huge tables out there... well, the query is taking forever...

... I'm not exactly sure what we can do here... Is there a way we can turn off the row count? or a way to have the row count calculated on the client instead of on the server?[size=9][/size]

Devart Team
Posts: 476
Joined: Fri 29 Oct 2004 09:25

Post by Duke » Mon 13 Apr 2009 07:20

To disable querying row count you need to turn on paginal mode for Data window and/or Data view of SQL document (Tools->Options->Devart Developer Tools->Data Editor->General).

Post Reply