| Provide me answers as soon as possible [message #256644] |
Mon, 06 August 2007 04:10  |
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: Indexes, functions and performance tuning [message #256679 is a reply to message #256644] |
Mon, 06 August 2007 05:29  |
 |
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
