Home » RDBMS Server » Performance Tuning » Indexes (merged 3)
Indexes (merged 3) [message #389711] Tue, 03 March 2009 06:20 Go to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Hi!!
Do I have to perform any optimization operation whenever I create an index, so as to make it take effect?

Thanks in advance,
Daniela.
Re: Indexes (merged 3) [message #389730 is a reply to message #389711] Tue, 03 March 2009 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Gather statistics.

Regards
Michel
Re: Indexes (merged 3) [message #389774 is a reply to message #389711] Tue, 03 March 2009 09:22 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
And if the "GATHER_STATS_JOB" is enabled, I ought to do nothing but wait until it runs, isn't it?

Thank you!!
Re: Indexes (merged 3) [message #389776 is a reply to message #389774] Tue, 03 March 2009 09:35 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
The index may well be used before stats are gathered for it - the CBO will assume a set of default values for it, and the RBO would just use it.

If it's an urgent problem you could run DBMS_STATS.GATHER_INDEX_STATS o or DBMS_STATS.GATHER_TABLE_STATS
Re: Indexes (merged 3) [message #389787 is a reply to message #389774] Tue, 03 March 2009 10:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
danyromimd wrote on Tue, 03 March 2009 16:22
And if the "GATHER_STATS_JOB" is enabled, I ought to do nothing but wait until it runs, isn't it?

Thank you!!

There is no such job in 9i.

Regards
Michel
Re: Indexes (merged 3) [message #389793 is a reply to message #389787] Tue, 03 March 2009 10:11 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Michel Cadot wrote on Tue, 03 March 2009 14:03
danyromimd wrote on Tue, 03 March 2009 16:22
And if the "GATHER_STATS_JOB" is enabled, I ought to do nothing but wait until it runs, isn't it?

Thank you!!

There is no such job in 9i.

Regards
Michel



But I'm using 10.2.0.1.0... I can't see that info now, but I swear I've put it down in the "Product, version, OS" field in "New topic"
Re: Indexes (merged 3) [message #389795 is a reply to message #389793] Tue, 03 March 2009 10:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Information that disappears during topics merge that would not be happen if you didn't multipost your question.

Regards
Michel
Re: Indexes (merged 3) [message #389798 is a reply to message #389711] Tue, 03 March 2009 11:00 Go to previous messageGo to next message
danyromimd
Messages: 73
Registered: August 2008
Member
Oh! I'm sorry for that. It kept on telling me there was an error and I thought it had not been posted.
Re: Indexes (merged 3) [message #389807 is a reply to message #389798] Tue, 03 March 2009 11:51 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Then verify before reposting.

Regards
Michel
Previous Topic: Package Tuning using Bulk Excpetion
Next Topic: Difference between cost and %CPU?
Goto Forum:
  


Current Time: Fri Dec 09 21:42:16 CST 2016

Total time taken to generate the page: 0.17567 seconds