Home » RDBMS Server » Server Administration » PCTUSED not permited with index (oracle 8i 9i 10g)
PCTUSED not permited with index [message #337393] Wed, 30 July 2008 14:37 Go to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member

Why does Oracle not permit the use of PCTUSED with indexes?

I will appreciate reply for my question...

Note:-I do have access to metalink and oracle documentation

Re: PCTUSED not permited with index [message #337394 is a reply to message #337393] Wed, 30 July 2008 14:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because it is meaningless.

Regards
Michel
Re: PCTUSED not permited with index [message #337395 is a reply to message #337394] Wed, 30 July 2008 14:54 Go to previous messageGo to next message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
Thank you very much michel...

Actually some one asked me that in interview ... Very Happy

I said user are not inserting in index Very Happy ... its upto oracle to manage size of leaf block.

I don't know i am right or wrong...
Re: PCTUSED not permited with index [message #337478 is a reply to message #337395] Thu, 31 July 2008 01:03 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The good answer to this question in interview is to explain what PCTUSED means and does, then how an index works and so you will show it is meaningless for an index.

Regards
Michel

[Updated on: Thu, 31 July 2008 01:04]

Report message to a moderator

Previous Topic: how to reduce the database size after dropping the schema
Next Topic: Different execution plans for same query ???
Goto Forum:
  


Current Time: Sat Dec 03 22:11:21 CST 2016

Total time taken to generate the page: 0.12500 seconds