Thanks for the reply, John. I found some info on SQL indexing but nothing specific to Jet/ACE.
Bill
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> Bill-
>
> I seem to recall a bug several versions ago regarding ascending /
> descending. If you created a descending index on a field, then tried to
> make it the Primary Key, Access would crash. This implies to me that Access
> (JET / ACE) does in fact build a descending index different from an
> ascending one. If this is true, then yes, it does make a difference.
>
> John Viescas, Author
> Microsoft Access 2010 Inside Out
> Microsoft Access 2007 Inside Out
> Microsoft Access 2003 Inside Out
> Building Microsoft Access Applications
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
>
> -----Original Message-----
> From: MS_Access_Professionals@yahoogroups.com
> [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Bill Mosca
> Sent: Tuesday, May 14, 2013 3:33 PM
> To: MS_Access_Professionals@yahoogroups.com
> Subject: [MS_AccessPros] John V...a JET index question
>
> Hi John
>
> I was in another forum and a question came up as to when one should index
> using descending instead of Ascending, and does it make any difference or is
> this just a way to present the data in datasheet view.
>
> I figured if anyone knew it would be you.
>
> Bill Mosca
>
>
>
> ------------------------------------
>
> Yahoo! Groups Links
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (3) |
Tidak ada komentar:
Posting Komentar