> The schema is VERY basic: > > CREATE TABLE [myTable] ( > [myKey] [bigint] NULL , > [NumOne] [int] NULL , > [NumTwo] [real] NULL , > [NumThree] [real] NULL , > [NumFour] [real] NULL , > [NumFive] [real] NULL , > [NumSix] [float] NULL , > [NumSeven] [float] NULL > ); > > CREATE INDEX myMyIndex ON myTable (myKey); > CREATE UNIQUE INDEX [pkPrimary] ON [myTable] ([myKey], [NumOne]); > CREATE INDEX myNumOneIndex ON myTable (NumOne);
Why did you chose these indexes? Updates and Inserts are faster with fewer indices. Perhaps they can be reduces? You do have a rather large database, you'll have to be pretty aggressive to get good performance from it. ===== --------------------------------- "Lord Tarlington gazed upon the crazed Egyptian hieroglyphics on the walls of the ancient tomb of the petrified pharaoh, he vowed there would be no curse on him like on that other Lord, unless you count his marriage to Lady Tarlington who, when the lost treasure was found, will be dumped faster than that basket in the bulrushes." Melissa Rhodes --------------------------------- The Castles of Dereth Calendar: a tour of the art and architecture of Asheron's Call http://www.lulu.com/content/77264 __________________________________ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com
