Re: Oracle performance decrease using Access7

From: Troy Perchotte <perchott_at_nospamdigitalcourier.com>
Date: Tue, 14 Apr 1998 19:10:47 -0700
Message-ID: <35341726.900C1F6D@nospamdigitalcourier.com>

Thanks John and Kevin,

This is strange. On one of the many times that I've been attaching to the Oracle tables from Access, I ignored the question that Access displays (and was giving immediate results):

"To ensure data integrity and to update records, you must choose a field or fields that uniqely identify each record. Select up to 10 fields"

On all previous attachments, I've been selecting the "CustID" field as the field that identifies the uniqeness for this table. Now even the 106 column table with 13'000 records displays within an acceptable 2 seconds.

Is there any reason why I would need to select any field for the Access question ("...you must choose a field or fields...")?

Troy Perchotte Received on Tue Apr 14 1998 - 21:10:47 CDT