On Mon, Mar 24, 2008 at 11:32 AM, Tracy Holzer <[EMAIL PROTECTED]> wrote:
> I agree. For example in a scan, as long as the FOR condition is > optimized, > the entire data is not transferred. If a query is rushmore optimized > then > only the relevant parts of the indices should be transferred to the pc and > then used to determine which records should be pulled across the wire. > Although I think the best optimization is achieved using a single > optimized > SELECT (one chunk of data versus numerous small chunks). > > Does anyone disagree or have anything to add? > --------------------------------------------------------------------------------- Tracy are you saying that if you have 4 columns of an index it will know which part of the index to suck down to your pc to process with? PK, FKtoTable1, FKtoTable2, DescriptiveColumn It has to pull down the index into ram and then parse out what portions to warrent usage. I don't think that pages of the index will be complete and consistent untill a reindex is done. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
