OraFAQ Forum: Performance Tuning » Indexes (merged 3)

Home » RDBMS Server » Performance Tuning » Indexes (merged 3)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Indexes (merged 3) [message #389711]

Tue, 03 March 2009 06:20

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.

Report message to a moderator

Re: Indexes (merged 3) [message #389730 is a reply to message #389711]

Tue, 03 March 2009 07:17

Michel Cadot
Messages: 68662
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Gather statistics.

Regards
Michel

Report message to a moderator

Re: Indexes (merged 3) [message #389774 is a reply to message #389711]

Tue, 03 March 2009 09:22

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!!

Report message to a moderator

Re: Indexes (merged 3) [message #389776 is a reply to message #389774]

Tue, 03 March 2009 09:35

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

Report message to a moderator

Re: Indexes (merged 3) [message #389787 is a reply to message #389774]

Tue, 03 March 2009 10:03

Michel Cadot
Messages: 68662
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

Report message to a moderator

Re: Indexes (merged 3) [message #389793 is a reply to message #389787]

Tue, 03 March 2009 10:11

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"

Report message to a moderator

Re: Indexes (merged 3) [message #389795 is a reply to message #389793]

Tue, 03 March 2009 10:28

Michel Cadot
Messages: 68662
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

Report message to a moderator

Re: Indexes (merged 3) [message #389798 is a reply to message #389711]

Tue, 03 March 2009 11:00

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.

Report message to a moderator

Re: Indexes (merged 3) [message #389807 is a reply to message #389798]

Tue, 03 March 2009 11:51

Michel Cadot
Messages: 68662
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Then verify before reposting.

Regards
Michel

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jun 18 00:50:30 CDT 2024