Oracle General steps to tune selectquery

2013-01-10  Source: Original Site  Category:Oracle  Views:1 

Advertisement

Hai friends,

Can u explain the general steps to tune a select statement.
like where to use where, functions having etc.. and which should be in the first.. Procedence order etc..

Related articles
  • Oracle General steps to tune selectquery 2013-01-10

    Hai friends, Can u explain the general steps to tune a select statement. like where to use where, functions having etc.. and which should be in the first.. Procedence order etc..

  • Oracle Steps to tune the query as a developer and no rights as DBA. 2012-11-09

    I need to tune the query. The query is something complicated which has many joins, group by, having and many more which querying from the table which has lakhs and lakhs records. I want to tune the query. I want all the type of tuning strategy to tun

  • Oracle Moving from one box to another....general steps? 2015-01-05

    Can someone describe the general steps when moving from one box to another? My situation is as follows... Box A Sparc Solaris 9, Oracle 10g Box B Solaris 10 x86, Oracle 11g I know there are many factors, but I'm pretty new to both unix & oracle,

  • Oracle General rules for query optimization 2013-02-10

    I am new to oracle and have read lots of articles over query optimization but i still cannot find the right answer as to what r the general steps for query optimization..for tuning ur application ? where should you start from what should be the inter

  • Oracle What step need to take to tune the below query? 2014-11-29

    select LPAD(' ', 2*LEVEL-1)||SYS_CONNECT_BY_PATH(USER_ID,'/') AS USER_ID, user_nm USER_NM,LEVEL AS MAX_LEVEL from ( SELECT /*+ use_hash(GS_USER)*/ DISTINCT null PARENT_USER_ID, USER_ID user_id, user_nm FROM GSUSER WHERE GC_DEALER_USER_FLG='G' AND USE

  • Oracle General notes around certification 2012-06-22

    Hopefully this will help short-cut some of the more repetitive posts we see in this forum. I will be linking to this thread, and encourage others to do so as well, instead of typing the same thing over, and over, and over. 1) Where to find out about

  • Oracle Want to fine tune database 2012-10-08

    I noticed some slowness for my oracle database during few time not as before. i want to fine tune that database could you help please what is the way i have to follow to fine tune my database in general. The database is on unix system and 10g version

  • Oracle Migration steps 8.1.7 to 9.2.0.4? 2012-03-25

    we are going to migrate the oracle 8.1.7 on solaris to oracle 9.2.0.4 on HP-unix, our database size around 60GB... and our teamleader tell me to migrate through export option....can anybody give me steps of migration.....i will be very gratefull.....

  • Oracle General group ettiquette 2012-03-26

    A couple of general group ettiquette reminders. Since the forum is running smoothly maybe they are not needed. But better to post now than to seem to scold someone by posting after a transgression. -- Ask SQL questions in the SQL forum: http://forums

  • Oracle General SQL Performance Question? 2012-04-03

    To start, I am a marketing user (horrors!) of an Oracle database and found this forum to ask a question because I think I am having performance issues but can't seem to convince a DBA of this. I came from a larger company where simple queries like a

  • Oracle Installation Steps 2012-05-24

    Can anybody guide/provide me the simplified steps of Oracle Installation on Linux AS 3. I have a test environment on which I can go through the installation of all the version. Please if you have; provide me.

  • Oracle Setup steps... 2012-07-16

    Hi, I am new to Oracle world and wondering if there is any document or link out there which gives me a list of steps needed to have oracle up and running on NT i.e. installation, instance, database creation etc. I am DB2 UDB guy so I do know rest of

  • Oracle General XML DB meltdown with good schemas and data, what is left to do? 2012-09-03

    We have carefully constructed XML schemas which describe the of a variety of server applications. We are talking about 200K of schema definitions scattered in about 40 files and perhaps 20 namespaces. They have to be registered with force=true becaus

  • Oracle AQ STEP BY STEP by Joel Pérez 2012-09-05

    I am a person that answer questions for some forums here. I have seen that a lot of people get trouble to begin to work with the Advanced Queing technology and my purpose with this topic is to guide rookies and everybody that wants to learn a little

  • Oracle REPLICATION STEPS 2012-10-26

    HI. DEARS I WANA IMPLEMENT MULTIMASTER REPLICATION , FOR THAT I REQUIRE U'R GUIDANCE. IF SOME OF U CAN GUIDE ME ALL THE STEPS I SHOULD TAKE TO SUCCESSFULLY IMPLEMENT. SUPPOSE 2 SERVERS SERV-A AND SERV-B ONE HAVE WINDOWS ADMINISTRATOR AND OTHER IS WIN

  • oracle database diagnostic and tunning pack 2012-11-10

    io want to down load diagnostic and tunning pack for oracle database release 8 or 8i for window NT. plzzz specify me the location from where i can down load it

  • Oracle Easy Steps to Package up an Application 2012-11-15

    Does anyone know of an easy step by step document on how to package up an application for distribution? Is says in the online Documentation at http://download.oracle.com/docs/cd/E14373_01/appdev.32/e11838/deploy.htm#CHDICGJD ..."Creating a packaged a

  • Oracle GENERAL LEDGER CODES 2013-01-25

    Hi, I am a New Oracle Developer using Oracle Express Edition now developing an Hospitality Management System. Can any one help on General Ledger scripts as I don't know any of the Accounting and finance concepts

  • Oracle General Error 2013-02-01

    I am Joshi. I am new to oracle. While i am working on some examples. I am getting some errors like No Data Found, Object Not found.. . Can i get some list of errors such that i can fix them and save my time. please any one help me to give me a doc wh

  • Oracle Need Steps of writing shell scripts to check DB health. 2013-02-17

    I need the steps to generates the emails from Linux OS to checking the oracle 10g database health, different thrashhold limits, and checking alert log file for ORA- ERROR etc.