| Cost Based Indexes [message #65307] |
Wed, 28 July 2004 22:21  |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Hi,
Can anybody give me the link for documentation of Cost Based Indexes. I'm working on a Database Project with Oracle 9i as Backend.
Thanking you,
Ronald.
|
|
|
|
| Re: Cost Based Indexes [message #65310 is a reply to message #65307] |
Thu, 29 July 2004 07:27  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Not quite sure what you are referring to: the "Cost Based Optimizer" or "Function Based Indexes"? Or, are you referring to how the Cost Based Optimizer will use/select Indexes?
Best regards.
Frank
|
|
|
|
| Re: Cost Based Indexes [message #65314 is a reply to message #65310] |
Fri, 30 July 2004 21:11 |
Brayan
Messages: 315
Registered: June 2002
|
Senior Member |
|
|
Hi,
I mean how the cost based optimizer works and on what basis it decides to select a particular index. And also, is it required to update the statistics of cost calculation, If so at what interval?
Regards,
Roanld.
|
|
|
|
|
|
| Re: Cost Based Indexes [message #65342 is a reply to message #65314] |
Wed, 11 August 2004 04:47 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
This is too much info for a simple reply. Best is to read the "Oracle Database Performance Tuning Guide and Reference". In particular, read chapter 1: Introduction to the Optimizer.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
