all,
the exmaples I have seen for FBIs are mostly of type
CREATE INDEX area_index ON rivers (area(geo));
but what if I have an expression like below?
mine is failing..
SQL> create index fb_idx_test on MONAGA (SMCID(<>0));
create index fb_idx_test on MANAGA (SMCID(<>0))
ERROR at line 1:
ORA-00936: missing expression
this is for a query that ends thus
where SMCID <> 0; => need to add the FBI here.
thanks