Re: Advice on SQL and records

From: Paul <>
Date: Tue, 23 Aug 2005 17:06:42 +0100
Message-ID: <>

"David Cressey" <> wrote:

> > What does "cardinality" mean? What's an "optimizer"?

> The cardinality of that table is the number of rows in the table.

Surely you mean records, or tuples? Rows are for spreadsheets.  

> The order of a table is the number of columns in it.
> "order" is a poor choice of terminology, since many people will read it as
> "Sort order".

That's maths for you - not always intuitive.



plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, (Enterprise Ed.)

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Furthermore, as a courtesy to those who spend 
time analysing and attempting to help, please 
do not top post.
Received on Tue Aug 23 2005 - 18:06:42 CEST

Original text of this message