Re: index advisor

Logical files can share access paths. This is also true, as I recall, of indexes, which are a special kind of logical file.

Indexes do have a potential performance benefit - they can have larger pages brought into memory at one time. But LFs work just fine, although some recommend indexes when used only for optimization.

Create the index with both key fields first, then the one with only FieldA. And remember that to share, they have to start with the same columns.

I know I'm missing some details, but I hope this gets you started. Try creating the indexes and see if the second one says it is sharing the access path - look at DSPFD.

Let me see, maybe if you create the longer index first and an SQL index, then create the logical with the single field, it'll share the advantage of the index' access path - it's been too long!!!

Back to work!

Vern

On 3/4/2013 1:55 PM, Stone, Joel wrote:

What columns should I review when determining which indexes to add to a database?


- Times Advised for Query Use


- Most Expensive Query Estimate


- Others?




If one row advises to add FieldA , FieldB, and a second row advises FieldA for the same file, would adding a logical file with keys FieldA & FieldB do the trick for both advising rows?

Does creating a LF benefit the same as adding an index?

Thanks



______________________________________________________________________
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________