Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> newbie index question
If I have an index on multiple columns, one of which is has a not null constraint, can I find out how many rows are in the index by simply doing a select count(*) on the table? My thinking is that since the column doesn't allow nulls, finding out how many rows in the table will tell me how many rows are in the index. Please advise...
-- PhillipReceived on Wed Feb 14 2001 - 16:51:23 CST