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