dbTalk Databases Forums  

default filegroup for creating indexes

comp.databases.ms-sqlserver comp.databases.ms-sqlserver


Discuss default filegroup for creating indexes in the comp.databases.ms-sqlserver forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
rcamarda
 
Posts: n/a

Default default filegroup for creating indexes - 03-12-2007 , 08:28 PM






As some readers of this newgroup can recall, I use Cognos' program
called Data Manager to build my data warehouse. I has the ability to
create indexes, however I cannot add other arguments to its command.
It has a basic command such as
CREATE INDEX PERSONNEL_ID ON
"dbo"."F_Personnel_Detail" ( "PERSONNEL_ID" )
The index by default is built in the PRIMARY filegroup.

I am testing out putting the indexes in their own filegroups and
testing performance and fragmentation management and I thought it
would be great if I could configure the database to use a filegroup
other than PRIMARY to build the index if the ON [INDEXES] argument is
not provied.
TIA
Rob


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.