OraFAQ Forum: SQL & PL/SQL » How to work oracle index

Home » SQL & PL/SQL » SQL & PL/SQL » How to work oracle index

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

How to work oracle index [message #611746]

Tue, 08 April 2014 06:45

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hi Guys,
Please let me know that how to work oracle full table scan index and rowid.

Report message to a moderator

Re: How to work oracle index [message #611747 is a reply to message #611746]

Tue, 08 April 2014 07:00

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

Let the optimizer decide. It's right 99.9x% of the time.

Report message to a moderator

Re: How to work oracle index [message #611823 is a reply to message #611746]

Wed, 09 April 2014 04:23

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

aaditya321 wrote on Tue, 08 April 2014 06:45

Hi Guys,
Please let me know that how to work oracle full table scan index and rowid.

I don't understand the question. Please eloborate.

Report message to a moderator

Re: How to work oracle index [message #611828 is a reply to message #611823]

Wed, 09 April 2014 05:23

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

Senior Member
Account Moderator

Even if we don't understand the question Roachcoach's answer is the best one.

Report message to a moderator

Re: How to work oracle index [message #611846 is a reply to message #611746]

Wed, 09 April 2014 06:55

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

You might like to go through this excellent explanation regarding FTS by Tanel Poder Oracle full table scans. You can ignore the other parts discussed in the link.

[Edit : Fixed typo]

[Updated on: Wed, 09 April 2014 07:36]

Report message to a moderator

Re: How to work oracle index [message #611905 is a reply to message #611846]

Thu, 10 April 2014 00:09

aaditya321
Messages: 225
Registered: January 2014
Location: Delhi

Senior Member

Hi Lalit, I am not satisfied from your given link.

Report message to a moderator

Re: How to work oracle index [message #611906 is a reply to message #611905]

Thu, 10 April 2014 00:39

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

aaditya321 wrote on Thu, 10 April 2014 06:09

Hi Lalit, I am not satisfied from your given link.

I'm sure that it is just a language thing, but the tone of your post isn't really acceptable on a public forum. If the link does not cover your question, the try to reformulate your question (it really isn't at all clear, as has been said both here and on other forums)

Report message to a moderator

Previous Topic:	Oracle - generating combination of numbers
Next Topic:	CONCATENATE QUERY

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 03:40:47 CDT 2024