RE: newbie index question

From: David Fitzjarrell <ddfdba_at_MailAndNews.com>
Date: Wed, 14 Feb 2001 18:52:46 -0500
Message-ID: <3A954FA5@MailAndNews.com>

If the index is unique on those columns, yes.

A more accurate assessment may be obtained by selecting the discinct index groupings from the table. If the index is built on columns a, b and c if you:

select distinct a, b, c
from mytable;

you should obtain a better picture of the index size, although this won't provide the actual index size by any stretch of the imagination.

>===== Original Message From Phillip <tienp_at_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

---

 Get your FREE web-based e-mail and newsgroup access at:

                http://MailAndNews.com

 Create a new mailbox, or access your existing IMAP4 or  POP3 mailbox from anywhere with just a web browser.

---

Received on Wed Feb 14 2001 - 17:52:46 CST