I got a problem here for the Oracle SQL, <br />one of my quries that :<br />Select <br /> enddate, <br /> enddate-durationtime as starttime...
got a question here
three tables A, B, C
base on the one field in Table A,
table A will inner Join the table B or Table C,
any idea ?
need to know 2 things
1 , what query runs most frequently ? or count of the times each query runs in 10 minutes
2 , how much cost for each query...
I have a big stored procedure, it use dynamic string to build the query and run the query by EXEC, but recently this stored procedure is little bit...
Separate names with a comma.