[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Re: SQR-USERS Digest - 17 Jul 1999 to 19 Jul 1999
- Subject: Re: SQR-USERS Digest - 17 Jul 1999 to 19 Jul 1999
- From: Anne-Marie Matula <amatula@OIT.UMASS.EDU>
- Date: Tue, 20 Jul 1999 09:59:22 -0400
- Importance: Normal
- In-Reply-To: <199907200602.AAA08807@list.iex.net>
>Krisjanis Gale <Krisjanis.Gale@NY.FRB.ORG> wrote:
>so i modified it by simply doing a cross-product
>of dba_tables and dba_tab_columns
>and did a select distinct / order by table_name.
>and then it only ran for about a half hour.
What exactly is a cross-product? A cross-tabular select? I just never heard
the term used...I hope admitting that doesn't boot me back down to newbie
programmer camp!
Have a great day!
Anne-Marie
P.S. I agree "SQR in PeopleSoft and other applications" is excellent! It has
a great section on optimizing SQL statements. I don't recall any other books
that had such a concise summary of that!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Anne-Marie Matula
Student Information System Project
Office of Information Technologies
Whitmore Bldg, University of Massachusetts, Amherst
Phone: 413/577-0685
Fax: 413/545-2150