Hi,
I have a problem in my below SQL,it took much time for getting the result(executio n time is around 10 minutes).This sql contains many functions and also a DISTINCT keyword and its mandatory.So request you to please provide me solution for this. Indexes are exits and also I have analyzed all tables which been used inside this SQL.
I have removed the DISTINCT keyword its gave me result but its return duplicate records so i need it...
kiranrajenimbalkar
Last Activity: Apr 30 '10, 08:40 AM
Joined: Jan 28 '10
Location: Pune,Maharashtra
-
Want SQL executing fastre
-
Hi
Above SQL giving no rows..
I want all records insert into that created table DN_UNCOMMON.
Please provide me the solution that how to create the above mentioned table. -
Create table
Hi,
I have to create table from one sql but its taking long time for creating the table so please provide the solution ASAP
...Code:CREATE TABLE DN_UNCOMMON NOLOGGING AS SELECT * FROM DR_CONTRIBUTION_DN dn WHERE NOT EXISTS ( SELECT * FROM DR_CONTRIBUTION_PS ps WHERE (dn.ID = ps.ri_donor_id AND dn.idtype = ps.ri_donor_type -
kiranrajenimbalkar started a topic How to stop execution when will get the ERROR in a perticular block?in OracleHow to stop execution when will get the ERROR in a perticular block?
Hi,
I have to execute below Anonymous Blocks script which inclide update script,but if suppose I will get error on block 5 then another block will not be execute i.e 6,7,8,9......la st block ,so please request to you that please provide me the solution ASAP how i will do this.
...Code:BEGIN UPDATE webuser SET registration_type = 2 WHERE registration_type IS NULL AND ID IN (3128, -
Hi,
Yes i am trying to refresh time i.e i have to change the JOB time from sysdate +1/2 to sysdate+1.so please provide me the SQL script for the same.
Regards,
KiranLeave a comment:
-
Materilized view JOB
Hi,
Please provide me the SQL for creating Materilized view JOB in Oracle or Changing the timing to sysdate + 1 from exesting JOB.
Regards,
Kiran -
Function took long time for execution..
Hi below function taking long time when i am going to execute this function.
CREATE OR REPLACE FUNCTION Getdistrictforu ser(PID IN WEBUSER.ID%TYPE )
RETURN VARCHAR2 IS
VCLUB VARCHAR(1000);
CURSOR CURSOROUT(PID VARCHAR2) IS
SELECT DISTINCT AD.DISTRICTID
FROM MEMBER M
JOIN CLUB C ON M.RCLBID = C.ID
AND M.RCLBIDTYPE = C.IDTYPE
... -
SQL Not working with the function
Hi,
These are the mendatoday things STRINGS and CONCAT operators.
Please suggest me if you have any new soltion for fetching the records fast.
Best Regards,
Kiran RajenimbalkarLeave a comment:
-
SQL taking long time for fetching the records
Quote:
SELECT A.ID,
A.IDTYPE,
A.USERNAME,
A.FIRSTNAME,
A.LASTNAME,
A.STATUS,
A.LANGUAGEID,
A.LANGUAGENAME,
GETROLESFORUSER (A.USERNAME) ROLES,
0 CLUBID,
A.ISDISABLED,
0 REGION
FROM (SELECT W.ID,
W.IDTYPE,
W.USERNAME,
P.FIRSTNAME,
P.LASTNAME,
W.ACCT_STATCD...Leave a comment:
-
SQL Taking Long time for fetching records
Please note below function "getrolesforuse r" is being called from above SQL.
I want select query posted above should fetch the records within half minute.Due to this function above SQL took long tome time for fetching the records so my application gets time out error.The aboue SQL was fetching only 5254 recodes for that...Leave a comment:
-
SQL Not working with the function
Hi,
when i am executing the below SQL its taking long time for execution so please provide me the solution.
...Code:SELECT A.ID, A.IDTYPE, A.USERNAME, A.FIRSTNAME, A.LASTNAME, A.STATUS, A.LANGUAGEID, A.LANGUAGENAME, GETROLESFORUSER(A.USERNAME) ROLES, 0 CLUBID, A.ISDISABLED, -
Thank you very much Amit for Quick Reply.
Thanks
KiranLeave a comment:
-
How to tune SQL...
I have a problem with one SQL.
Its not fetching the records its took very long time for execution.
Please see the below SQL
SELECT A.ID,
A.IDTYPE,
A.USERNAME,
A.FIRSTNAME,
A.LASTNAME,
A.STATUS,
A.LANGUAGEID,
A.LANGUAGENAME,
GETROLESFORUSER (A.USERNAME) ROLES,
...Leave a comment:
No activity results to display
Leave a comment: