Re: Primary Key and Indexes, are they necessary?

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Wed, 14 Jun 2006 01:59:42 GMT
Message-ID: <Xns97E1C15C9B295ianalvistahotmailcom@70.169.32.36>

jchen.com_at_gmail.com wrote in
news:1150249244.705119.163690_at_f6g2000cwb.googlegroups.com:

> Yes we are experiencing performance issues, especially for report
> generation.
>
> John Chen
> =========

You are a nasty top poster who may limit responses by repeating this behavior.

Indexes may or may not speed up reporting generation. It depends upon the actual SQL issued.

There are NO silver bullets when it comes to RDBMS. It depends upon any number of metrics including actual data. Received on Tue Jun 13 2006 - 20:59:42 CDT