Hi All, I have a query, I created global index on table of 10,000,000 records. My global index's state is stuck at "BUILDING". I have tried running this query :
*alter index accrual_client_ref_id_type_idx on apl_accrual_service.accruals USABLE; * which says the same. The global index has 10k rows less than main table. What are my options to fix this? Do I have to rebuild the index to fix this?
