Database Administration (MOSC)

MOSC Banner

index issue

edited Dec 2, 2008 12:20AM in Database Administration (MOSC) 1 commentAnswered
Let's say I have a table with 4,500,000 rows.  I would like to create an index on column x. In 4,300,000 rows of the table, the value of column x is 0 while the remaining 200,000 have a value. Would I have a problem with this index and if yest what type of problem?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center