creating index

[iffoiffy]

Hi,

Is it Ok two create an index on a field after enetring data ..or will it cause any problem has to be when you create a table?

Thanks

 

[TonyGroves]

1. Yes
2. No

 

[r937]

1. yes
2. no, unless you are trying to create a unique index, and the data that you entered already has duplicates

rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[iffoiffy]

suppose I am creating an index on a field called "product_price". I am doing so because i want people to be able to search by price. This field will offourse have duplicate field as more tha one product can have same price. So you are saying index is only for a fields that has unique values in it? right?

 

[TonyGroves]

Not at all, what you propose is perfectly feasible.

A "unique index" is a special kind of index which forces the associated column(s) to have unique values.

Just use an ordinary index on the product_price field.

 

[r937]

no, i am saying that if you want to declare a unique index, you would have problems if there were duplicate values in the column already

obviously, for price you would not want a unique index, just a regular index

but we didn't know that from your first post



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[iffoiffy]

thank a lot