Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
New to SQL, performance issues with query.
Jim, Thank you for the feed back. And although the query is running faster and meeting my needs for now, I am interested in learning more about sql tuning. I looked on http://tahiti.oracle.com for the P&T Manual but didn't find it in a search, or by just browsing around. As for my hard...- AZN2SQL
- Post #11
- Forum: Oracle: All versions
-
New to SQL, performance issues with query.
Ties, That worked out.. I did a query and pulled out the PK_QUESTIONVERSIONID ID's for the QUESTION table (lucky for me their were only 18 of them). I then replaced the trim(QUESTION.QUES_VER_CONTENT) IN ('Would you like to be contacted?', 'Are you happy with the service?') with an IN...- AZN2SQL
- Post #8
- Forum: Oracle: All versions
-
New to SQL, performance issues with query.
First off, thanks so much for the feed back!!! Ok I'm not the dba, but a user of the data (read only access only). I did check with the dba and the tables are monitored and stats are ran regularly, as needed. I personally don't have the ablility to run the trim/update on the field...- AZN2SQL
- Post #5
- Forum: Oracle: All versions
-
New to SQL, performance issues with query.
Hello all, I'm new to the forum and had some questions about a query I'm trying to speed up. Here's the environment, Oracle db (version 9) and I'm querying 4 tables. The tables and sizes are: Table row count QUESTION 193,336 survey_custom 3,600,279 survey_results...- AZN2SQL
- Thread
- Replies: 10
- Forum: Oracle: All versions
