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!
-
Sql Performance
Hello This query is taking 12 minutes to execute because of the correlated subquery.I need to rewrite it so that it takes very less time.Can Some one help please ? select count(*) from service_requests sr , appointment_statuses appst , appointments app , service_request_processing srp ...- 14w6119
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Urgent
Hello This query is taking 12 minutes to execute because of the correlated subquery.I need to rewrite it so that it takes very less time.Can Some one help please ? select count(*) from service_requests sr , appointment_statuses appst , appointments app , service_request_processing srp ...- 14w6119
- Thread
- Replies: 2
- Forum: Oracle: All versions
