21 Temmuz 2014 Pazartesi

ORA-20000 Oracle text error DRG-10599 column is indexed

I was trying to compare LIKE  operator and CONTAINS function inside a query to analyse their speed to retrieve data.

I used HR Sample Schema table EMPLOYEE.


What i had to do is to create an index on the column which i tried to retrieve data from.

Then the problem was solved.

But the speed differed at each time that i compiled the queries one to another.I could not come up with an overall idea about using CONTAINS function.

I did the same operation with a table which has million datas in it.

Contest won by CONTAINS function by multiplying five times earlier the operator LIKE.



Index is significant. Speed is important. Experience of database you are using considerably makes difference.


Hiç yorum yok:

Yorum Gönder