To Index or Not To Index or How To Index
I was wondering if someone knows a better way to explain how different indexes
work. Such as, is it better to have an index with int type or char or varchar
etc? Is it better to have composite indexes or indexes with individual columns?
How does optimizer handle different indexes and what can we do help it? Indexes
are very efficient most of the time but they can be quite detrimental to
server's performance, if abused. Perhaps you know of a good article about
indexing that you could share with us. Or, perhaps Mr. Rob Verschoor would like
to issue an article in his very usefu...Populating indexed versus non indexed tables
All - I need to populate a series of tables using MySQL under Win2k. The
source data will be in ~20 files.
In terms of time, is it best to populate the tables and create the indexes
afterwards? Or, should I create the indexes when I create the tables?
I know that it takes a little longer populating an indexed table. But is it
still faster than creating indexes afterwards? Some of the tables might be
fairly large (a few million records each).
Agile Communications, Inc.
Mark Riehl wrote:
>...No table index exists or at least one table index column is not included in data source. Data can be displayed but not updated.
No table index exists or at least one table index column is not included in
data source. Data can be displayed but not updated.
I get this error when trying to build a form, i'm connected to a remote
database, the DBA states I have permissions on the tables i'm working with.
There is no index on these table, all columns in table are being included
in form i get this error. Been unable to find any info on this error in
user documentation. Thanks in advance.
Forms require that there is a unique index / primary key on a table. If
neither of those exis...To Index or not to Index (that is the question...)
I'd like to clear up an assumption I have.
If I have a Primary Key Constraint on a Table I assume that I will not need
to create an Index on the field(s) of the constraint as the action of
creating the primary key constraint produces what is the equivalent of an
Index (be the constraint clustered or not).
Is this the case?
Also I'm looking to Pivot some data, are there any SQL tricks etc. I should
be aware of to be able to do this (I've searched the Newsgroups for 'Pivot'
but don't understand any of the answers posted - some SQL examples would be
gr...Switching a table from a clustered index to a non-clustered index.
I've been using CAST to set my table properties but now I must learn the
proper syntax in order to adjust the table settings from iSQL. Currently
table A's index is set to clustered but I want to convert it to a
non-clustered index. Does anyone know the command line that I should use?
Drop & recreate the index ( Primary key )
alter table table_name
drop constraint constraint_name
alter table table_name
add constraint constraint_name PRIMARY KEY NONCLUSTERED ( col )
...index server not indexing
Ok, so I want to add a catalog to the index server. I can add the new catalog, I then add a directory to this catalog. I restart the index server, and merge the index. If I click the index server, in mmc, it shows 0 documents for everything. Everything meaning documents to index, total docs, docs defered for indexing and so on.
I've tried this on vista as well as on win2003 and the same result is obtained, no documents are indexed. In win2003 I can index document, but ONLY the ones in the default catalog, if I paste some documents there they get indexed.
So, what have I don...Indexs on Views (Do the call to a view uses index on a table)
Hi I have created a view on my server A which is caling a table from Server B. The table that its calling has a bunch of index on it. Now I want to know does a call to this view, considers the indexes on my table on server B. Its taking a lot of time to respond so I am thinking its not considering the indexes but pls shed some light on it. I am not very good with Views and Indexes. Have something like this on server A Create view history as Select * from ServerB.siq.dbo.History Please help Thanks -
SarahSarah Cameron Benjamin
Have you checked the Execution Plan for your qu...Can we use Microsoft indexing service for the indexing of Database tables.
can we use microsoft indexing service for the indexing of Database files.
if yes give me description.
Hi ramkoti ,
Refer the below links :
...sa_migrate create index problem (more than 8 index per table)
Is anybody have problem creating index while migrating a
consolidated database to a ASA database. I'm having problems
: with tables having more than 8 index. Under 6 index per
table seems to work fine. The procedure sa_migrate seems to
have problem with more than 8 index/table.
What version of ASA?
What kind of database is being migrated?
What exactly is the symptom or error message?
On 27 Feb 2006 12:02:48 -0800, Timrek wrote:
>Is anybody have problem creating index while migrating a
>consolidated database to a ASA database. I'm having problems
>...Basic Index question :- nonclusted indexes which are a subset of a clustered index
Can anyone suggest why I would have the following set of indices upon a
index1 clustered, unique field1,field,field3,fiel4
index2 nonclustered field2,field3, field4
index3 nonclustered field,field2,field4
The table is one into which a lot of inserts are done, so I would have
thought that index2 & 3 would be unncessary since they're
(1) already in the clustered index and
(2) any inserts would triple the amount of index updates that are
Are these assumptions correct ?
Thanks in advance,
if you have a...Table Indexes
Can anyone please suggest some solutions on this:
I need to calculate the segment size for a table with over 300 million
rows. thsi table has 1 clustered and 2 non clustered indexes. what is the
best way to calculate the segment size and the sizes of each indexes .
any help will be greatly appreciated.
How about the sp_estspace stored procedure?
> Can anyone please suggest some solutions on this:
> I need to calculate the segment size for a table with over 300 million
> rows. thsi table has 1 clustered and 2 non clustered indexes. what is the
Just curious, I never care to use table index before.
when setting up table, just set primary key and done.
Is index really speed up table? Cause up till now i didn't notice the
difference between using and not using one.
In article <443c50b7@forums-1-dub>, firstname.lastname@example.org says...
> Just curious, I never care to use table index before.
> when setting up table, just set primary key and done.
> Is index really speed up table? Cause up till now i didn't notice the
> difference between using and not using one.
An inde...Index Name from Index ID
Have an error reported in log and I want to find the index name, the
error has provided the database name and table name but only the index
id. Is there any easy way of doing this ?
"mully" <email@example.com> wrote in message
> Hi there,
> Have an error reported in log and I want to find the index name, the
> error has provided the database name and table name but only the index
> id. Is there any easy way of doing this ?
>...How to index a table?
sorry for posting a question that has probably been posted hundreds oftimes, but i can't seem to find the answer i need...We're using a SqlServer 2005 database and recently started getting timeout expired, which i'm assuming is due to the volume ofrecords in our tables. Unfortunately i'm not too experiences w/indexing tables, so my question is:
1) how do you determine which fields to index (does it have to be afield w/ no nulls, no duplicates..similar to primary key), and why notindex the primary key
2) is it better to index the same field on different tables, or is it...