Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> newbie index question

newbie index question

From: Phillip <tienp_at_wholefoods.com>
Date: Wed, 14 Feb 2001 22:51:23 GMT
Message-ID: <3A8B0E1E.F2B02F22@wholefoods.com>

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...

--
Phillip
Received on Wed Feb 14 2001 - 16:51:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US