• SwePeso (12/9/2013)


    Here is a link to download the schema of my hybrid solution.

    It can also be found on my web page http://www.sqltopia.com[/quote%5D

    Just starting to try to get my head around your schema...a couple of questions.

    1) Most of the tables have primary keys, except factHeuristic and factPair, however both of these have Unique Clustered Indexes and no nullable columns. Any chance of an explanation as to why you didn't go for a PK? I'm thinking it has got something to do with the Partition Scheme?

    2) I'm interested in using this technique for an Oracle solution, but Oracle doesn't support included columns in indexes. Any thoughts on my chances of success - or is this key? Could I for example create new or extend existing indexes to literally cover these included columns?

    I'm working from the pdf document...I wonder has it been written up in more detail elsewhere?

    It really does look very promising, but not easy for a aging brain like mine to digest.

    Many thanks,

    David McKinney.