Create Indexes & extra columns!

From: Jonas Larsen (Jonas.Larsen_at_Alcan.com)
Date: 08/25/04 

Date: Wed, 25 Aug 2004 14:43:56 +1000

Hi guys

2 questions.

Is it recomenable to create
1. Indexes
2. extra columns

on a table while the database is being used?

I have not yet had the guts to do it while the database was in use however
it would be somewhat easier if I could?

Regards
Jonas

Relevant Pages

  • Possible ways to link existing user table into SQLMembershipProvider?
    ... I have membership working well and I'm trying to integrate it into a ... database that makes heavy use of a pre-existing 'User' table. ... table with a few extra columns and a 'loginname' column to join back to ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: Will ASP query be slow if field names are lengthy?
    ... Its a very bad idea to add extra columns just for description, ... your database is going to be that large you might consider using SQL Server ... > the query.asp would just show a list of the last 3 months worth of ...
    (microsoft.public.inetserver.asp.general)
  • Re: Create Indexes & extra columns!
    ... > I have not yet had the guts to do it while the database was in use ... index is a more time consuming process if the table is large. ... create a clustered index, you'll likely take the table offline until the ...
    (microsoft.public.sqlserver.server)
  • Re: Convert from WrapText
    ... Will try memo. ... Regards. ... > A record in Access or any other database is one row. ... >> the data in as close a manner as to that displayed in Excel, ...
    (microsoft.public.excel.programming)
  • Re: DSNLess connection
    ... Regards ... DO NOT stick the database in reach of the outside world (stick it ... > Steven Burn ... > Ur I.T. Mate Group ...
    (microsoft.public.inetserver.asp.db)