Fixing out of sync cross reference¶
To speed up query execution, Octo automatically builds cross references for every <table_name, column_name> pair as needed. It has been observed that in rare cases (see YottaDB/DB/YDB/#659 for details) the cross references can get out of sync. If you encounter such a situation, run the following command to rebuild the cross reference for a particular <table_name, column_name> pair.$ $ydb_dist/yottadb -run %XCMD 'KILL ^%ydboctoocto("xref_status","*<table_name>*","*<column_name>*")'
The above command invalidates the current cross reference.
Run your original query, in Octo, to rebuild/fix the cross reference.