OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » indexing (Oracle 10g)

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

indexing [message #573130]

Fri, 21 December 2012 03:50

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

I want to learn more about indexing and its advantages from the begining and to utilize its benefits, can someone refer to some documents , there is one blog in this orafaq but some concepts are little vague like b-tree.

Report message to a moderator

Re: indexing [message #573131 is a reply to message #573130]

Fri, 21 December 2012 04:02

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As usual Database Concepts

Regards
Michel

Report message to a moderator

Re: indexing [message #573451 is a reply to message #573131]

Fri, 28 December 2012 12:26

msol25
Messages: 396
Registered: June 2011

Senior Member

Hi Arif,

Please read the basic sql by oracle press for getting knowledge about indexing then read Performance tuning guide by oracle press for knowing
power of indexing.

Report message to a moderator

Re: indexing [message #573462 is a reply to message #573451]

Fri, 28 December 2012 22:06

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

thanks msol25 for referring me to those documents , can you post a reference link to them.

Report message to a moderator

Re: indexing [message #573472 is a reply to message #573462]

Sat, 29 December 2012 01:56

Michel Cadot
Messages: 68731
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What about Google?
Still lazy? Or dumb?

Regards
Michel

Report message to a moderator

Re: indexing [message #573474 is a reply to message #573472]

Sat, 29 December 2012 03:26

arif_md2009
Messages: 732
Registered: May 2009
Location: United Arab Emirates

Senior Member

none of them michel.I will do the search.

Report message to a moderator

Previous Topic:	Sql query taking High CPU and execution time in oracle 11gR2
Next Topic:	Tuning the sql query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 18 01:00:38 CST 2025