RE: SQL sort

You can use either a logical (eg. View) or a physical file (table) as your
business needs and DB definitions allow and require. What you should cannot
do (IIRC) is to reference an SQL index directly. Nevertheless, having the
right indexes will do wonders (in terms of performances) when accessing
your tables and views.

I, for example, am a fan of using views as a way of encapsulating some
business processes and methods. With them I don't have to reinvent the
wheel every time I have to, say, select to tables according to a particular
column (eg. date, customer number, etc). Just query the appropriate view
and "voilá", the info is there...

HTH,

Luis

Sent from my Moto G phone. Please excuse my brevity.
On Sep 3, 2015 3:59 PM, "Alan Shore" <ashore@xxxxxxxx> wrote:

Hi Booth

I understand and agree with your comment about your biggest problem being
that you haven't yet figured out how to ask the right questions.

I have been using SQL for quite a few years now - and I STILL not yet
figured out how to ask the right questions.

When I first started using SQL - I was told - ALWAYS use the physical with
your selects (or omits) within the SQL script (although I could never find
out why)

I followed this directive UNTIL I had to run one particular (relatively
simple) SQL script.
It gave me the answers I was looking for - but it took a rather long time
to run - 20 minutes or so - a LARGE file
So just for the hell of it, I changed the script to use a logical (for the
selects and omits) and it literally took seconds - with the same results

Nowadays - I still tend to use the physical - but I keep the idea of using
a logical in the back of my head
Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Booth Martin
Sent: Thursday, September 03, 2015 4:15 PM
To: Midrange Systems Technical Discussion
Subject: SQL sort

I am fairly new with SQL so please excuse what are most likely very simple
questions.

I am looking to understand the pros and cons with SQL.
On large files with data that will be used in various applications and in
various sort-by schemes, are logical files a help?
If so, does one reference the physical file and then SQL finds the best
logical, or does it help to specify a specific logical file?
What is the right way to collect a set of records equal to SFLPAGE?

So far, I believe my biggest problem is that I haven't yet figured out how
to ask the right questions.


--
Booth Martin
www.martinvt.com
(802)461-5349

If the world comes to an end, I want to be in Cincinnati. Everything
comes there ten years later. -- Mark Twain
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.