Forum Post: RE: Getting error while adding an index to a table.

Status
Not open for further replies.
A

anzeljamal

Guest
Thanks George for the information. I have written a query on the table and in the where clause i have specified that field directly equals to ?. But i couldn't find a record. Then i tried to deactivate all the indexes from the table and made one index active, which was not a primary index. Then i modified the query to pick that index and additionaly added the condition to check for that particular field equals ?. I found one record matching my condition. I have updated that record and again i have verified whether there record is updated or not. I didnt get any record matching the condition after that. Then i have activated all the indexes and then tried to load the df. Still i face the same issue. Also can you please explain me how to do idxbuild without sorting on disk ? Is it possible to do in version 10.2b ?

Continue reading...
 
Status
Not open for further replies.
Top