Monday, January 29, 2007

resources for figuring out ODBC index() function

Microsoft:
(edited: man what a day)
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odbcsqlstatistics.asp
(bottom of the page, thanks to Paul Rogers, I'm not sure I ever would have found it on my own.)

For Oracle, you probably want to avoid the indexes() function, and do queries straight to the system tables:
http://www.ss64.com/orad/ALL_IND_COLUMNS.html
http://www.ss64.com/orad/DBA_INDEXES.html

1 comment:

Matthew said...

Hi Chris. Interesting Blog.

We seem to travel in similar circles; you might enjoy my blog - xndev.blogspot.com.

What you say below about better analogies for development is similar to the point I'm trying to make with Blue Man Group. Well, sorta. Anyway, we should probably chat sometime. My email is Matt at xndev dot com.

Regards,

--heusser