Home » Other » Training & Certification » Provide me answers as soon as possible
Provide me answers as soon as possible [message #256644] Mon, 06 August 2007 04:10 Go to next message
swapnajojo
Messages: 40
Registered: June 2007
Location: India
Member
1)How wil you determine to go for which index

2)what should you answer when you are asked about the differnces in functions and procedures

3)how will you make sure your query is an optimised one
Re: Provide me answers as soon as possible [message #256668 is a reply to message #256644] Mon, 06 August 2007 05:18 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With such a title you are sure to get no answer from me.

Regards
Michel
Re: Provide me answers as soon as possible [message #256676 is a reply to message #256644] Mon, 06 August 2007 05:27 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Would you just like us to take the interview for you?
Re: Indexes, functions and performance tuning [message #256679 is a reply to message #256644] Mon, 06 August 2007 05:29 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
First of all: congratulations on choosing one of the worst titles possible.

swapnajojo wrote on Mon, 06 August 2007 11:10
1)How wil you determine to go for which index
I'd look at the usage. How are records fetched from a given table? What's the size? Are there a lot of DML operations on the table? If so, how are the records updated? One by one? In bulk? There are a lot of factors involved.

swapnajojo wrote on Mon, 06 August 2007 11:10
2)what should you answer when you are asked about the differnces in functions and procedures
A function has a return clause and can be used in SQL queries (provided that it doesn't change data).

swapnajojo wrote on Mon, 06 August 2007 11:10
3)how will you make sure your query is an optimised one
If it returns the data in an acceptible time (note that this is a subjective criterium), if it doesn't contain implicit casting. But again: there are a lot of factors involved. Are the statistics up to date? Are the necessary indexes in place?

I'd have a look at the performance tuning guide.

MHE

[Updated on: Mon, 06 August 2007 05:29]

Report message to a moderator

Re: Provide me answers as soon as possible [message #256907 is a reply to message #256644] Tue, 07 August 2007 01:39 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

With Others comments.

Visit Oracle Documentation and Search on Google AS SOON AS POSSIBLE.

For your help
http://tahiti.oracle.com
http://www.google.com

Regards
Taj

[Updated on: Tue, 07 August 2007 01:41]

Report message to a moderator

Previous Topic: can we call a procedure from a trigger and a trigger from procedure
Next Topic: Appex Training
Goto Forum:
  


Current Time: Thu Mar 28 17:14:20 CDT 2024