Prev Previous Post   Next Post Next
  #1  
Old 16th June 2010, 08:53 PM
Dave Sellers
 
Posts: n/a
Default Direct access to an index and its keys

I have a requirement to provide a list of all the distinct keys in an
index and the number of occurences of each key. At the moment I open a
table, set the appropriate index and in a 'while not table.eof' loop I
compile a list of keys and their number.

I'm assuming that while this is going on, all the records in their
entirety are coming across the network from the server so, on a slow
network there's a massive overhead just to get at the index keys.

Is there a more effivicient any way of getting at an index and its keys?

Dave


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sequential Access Index Manfred Abeln nexusdb.public.support 4 16th December 2009 11:48 AM
Sequential Access Index Manfred Abeln nexusdb.public.support 0 9th December 2009 08:53 PM
Sequential Access Index Paul Hughes nexusdb.public.support 2 29th June 2009 10:11 PM
Adding a Sequential Access Index Luke Johnston nexusdb.public.support 2 12th October 2007 06:38 AM
Simple question as regards direct table access vs. SQL Robert Meek nexusdb.public.support 21 30th January 2006 11:51 PM


All times are GMT +11. The time now is 05:15 AM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.