Re: SQL Indexes

Hi Don

You might know this already, but the archive might not - indexes might
not be used to retrieve rows, it might just be used by the optimizer to
be sure the best choice is being made.

So you don't necessarily want to delete indexes if they don't seem they
were used for retrieving rows.

Cheers
Vern

On 7/26/2018 9:53 AM, Don Wereschuk wrote:

Thanks everyone for all your information. I was able to figure out why

and when (what process, not what date/time) these indexes were being
created. Now I can figure out which ones I can delete and which ones I can
keep. Thanks again.

(PS. I cc'd everyone I thought should be aware of this but if I've

forgotten anyone then my apologies and could you please forward this to
anyone you feel should be informed.)

******************************************
Don Wereschuk
ISD - Programmer/Analyst
Simcoe Parts Service Inc.
Phone: 705-435-7814 Ex: 5325
Fax: 705-435-5029
mailto:dwereschuk@xxxxxxxxxxxxxxx
******************************************
If you can't describe what you are doing as a process, you don't know

what you're doing.

W. Edwards Deming

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of

Dan

Sent: July 25, 2018 6:53 PM
To: Midrange Systems Technical Discussion
Subject: Re: SQL Indexes

I've been known to use longer than 10 char names when I'm using SQL to

research data and create temporary work tables, so that the table name
provides a good clue of the specific data in the table.

I never do that for production tables.

- Dan

On Wed, Jul 25, 2018 at 3:20 PM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

On 7/25/2018 2:42 PM, Don Wereschuk wrote:
Yes, you can do a CREATE INDEX ABCDEFGHI_keyed_by_customer_name and
it's a perfectly legitimate table name, if a bit whimsical :-/

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a

moment to review the archives at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related

questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: http://amzn.to/2dEadiD

--
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: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD