 |
|
|
|
Next: how to refresh a sequence
|
| Author |
Message |
External
Since: Feb 23, 2005
Posts: 1
|
(Msg. 1) Posted: Wed Feb 23, 2005 4:40 am
Post subject: Using NonUnique Index to Enforce Uniqueness
Archived from groups: comp>databases>oracle>misc (more info?)
|
|
|
|
|
| Back to top |
|
 | |
| Related Topics: | Performance: BITMAP index vs. Non-Bitmap Index - Hi, in the explain plan of an sql-statement I have the following part: BITMAP CONVERSION TO ROWIDS and then a Bitmap-Index is used. Now, I deleted the Bitmap-Option from this index and the sql-statements are performing much better. They only need 20% o...
index - Hi all, I read the following in a book 1) we can have several non clustered indexes on a table , but we can have only one clustered index per table 2) index on the primary key can be clustered or non clustered now my question is 1) by default..
Why would an index not be used if specified as a hint in a.. - Hi, Running Oracle 8.1.7.4 on Solaris 2.8. Running explain plan, and then a query (I don't have a copy to show at this point), apparently the index is not used. I assume it is because the optimiser thinks the index is not required even though it is..
error on index - Hi can someone tell me what is the meaning of this error: ORA-13223: duplicated record in STRADE.THE_GEOM in SDO_GEOM_METADATA ORA-06512: a "MDSYS.MD", line 1723 ORA-06512: a "MDSYS.MDERR", line 17 ORA-06512: a "MDSYS.SDO_GE...
Index access vs Ignored hints - I have a question on some information that has been passed on similar threads. Specifically concerning the possibility that Oracle would never ignore a hint, if it can be used. (I though that a hint was never guaranteed to be followed) We have a rather.... |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
