Where Do I Want To Go Today? - Bidirectional Indexs
-
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/wheredoiwanttogotodaybidirectionalindexs.asp
-
Hi Steve
I think, with all of your "Today" comments, is Microsoft should take a long hard look at the environment around them, namely Oracle, DB2, CACHE, and other databases. All implement some very cool features that, picking selected ones, will really make the DBMS stand out. For example, down the oracle space:
a) Partitioning - should be mandatory in the SQL Server space
b) Bitmap and Function based indexing
c) Clustering like Oracle RAC (single database, many simultaneous instances running against it)
d) Import/Export utility (in one single package/command line with dependency checking etc)
e) remove the dependency of sp_refreshview
f) command of some sort to check stored proc syntax, even if they are encrypted
g) on login etc triggers
h) "out of the box" auditing without the need for sql-profiler setup
i) SQL extensions for quering hierarchies
<<..etc..>>
The reversed compound index is a good idea, no matter the order of my columns, the optimizer should pick it up.
Anyhow, just some thoughts..
Cheers
Ck
Chris Kempster
Author of "SQL Server 2k for the Oracle DBA"
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA" -
Oracle Schmoracle. Hopfully they'll implode themselves!!!!
But some good suggestions. I still think the best bang/buck is SQL Server, ease of use, tools, etc. But for sure there is room for improvement. I am really looking forward to Yukon. Maybe with the delay's they'll inforporate some of my suggestions.
Any MS appreciative royalties can be Paypal'd to sjones@sqlservercentral.com.
Steve Jones
-
Unless I misunderstand your wish, SQL Server already does what you want. It can use an index forward or backward.
Cindy Gross
Cindy Gross
http://cindygross.tripod.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply