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...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...Questions about Indexing and Using an Indexing POA
Although I have only about 50 users, at least 15 of them have in excess
of 100,000 messages in their accounts and the POA (version 7.0.2) is
regularly slowing to a crawl. (I just know that plans for revolution
are fomenting!) I have embarked on a campaign to reduce these accounts
by archiving everything off to get mail accounts down to 3000 or fewer
pieces. I have achieved user buy-in, but have worked on only a few
users so far.
In another closely related thread, it was suggested to me that the PO
speed issues relate to broken indexes. And I suspect that given so many
messages...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...A question about clustered indexes forcing rebuild of non-clustered indexes.
So I'm reading http://www.sql-server-performance.com/tips/clustered_indexes_p2.aspx and I come across this:
When selecting a column to base your clustered index on, try to avoid columns that are frequently updated. Every time that a column used for a clustered index is modified, all of the non-clustered indexes must also be updated, creating additional overhead. [6.5, 7.0, 2000, 2005] Updated 3-5-2004
Does this mean if I have say a table called Item with a clustered index on a column in it called itemaddeddate, and several non-clustered indexes associated with that table, that if...Index Questions
I was wondering if the order in which indexes are created, as well as, the
position of the column is located in table.
I have a table with 40+ fields. Over time, I've just been appending fields
to the end of the table and then indexing them. There are approx. 30
> I was wondering if the order in which indexes are created, as well as, the
> position of the column is located in table.
> I have a table with 40+ fields. Over time, I've just been appending fields
> to the end of the table ...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 ?
>...MS Index Server, Web Page Searches
I have the service set up and running and I'm able to do searches on my website and return the results to a search page. The basics are fine and up and running.
Question: I find when I publish the website if the '[x] Make site updateable' checkbox isn't checked the .aspx pages do not show up in a search. Is it true that the site must be published as updateable in order to make the MS Indexer work? Am I sacrificing security in order to get the pages indexed? Is there a way to publish the site as not updateable and still have the indexer work?
If I have a table with a foreign key into another table, will the
optimizer use that as an index for other purposes as well, such as joins
to other tables (not the one the foreignkey is referring to) or 'where'
clauses. Or do I need to put in an explicit index for those purposes?
The reason I'm asking is that a query which uses a join into this table
was giving me a sequential scan of this table even though there was an
index available in the form of the foreign key. I can't tell if that's
just because the optimizer thought this would be faster (since it's ...Crawler Index and FIle Index
I have setup the Apache web services as well as Quickfinder for my Netware
The Crawler works fine, finds all the hits I am looking for and opens the
file on my data volume.
However, when I setup a File System Index it does not open anything.
I have double checked my paths and syntex.
The thing that I have noticed is that when I search for a file with the
Crawler index and highlight the file, the path at the bottom of my browser
is like the following example.
http://myserver/comp/docs/myfile. showing the server name not an IP
address, which is fine and works!
I'm a bit unsure about a topic after reading the ASA 9 documentation:
automatically generated indexes with respect to primary keys and foreign keys
constraints. The documentation suggests that ASA 9 engine automatically indexes
both primary and foreign key columns upon creation of the constraints. In the
past we have practiced creation of foreign key column indexes manually, but now
I am thinking this practice may now be counter-productive in terms of now
forcing the database to maintain two indexes on the same set of 'foreign key'
Am I correct to assume...Placing indexes in index table
I have an Oracle 8.1.7 database and right now when I have Power Designer
9.5 create the script to create the database, the indexes have no
tablespace attached to them, so they are placed in the USERS tablespace.
Can someone explain to me the steps that need to be performed to have the
indexes to into the INDX tablespace? Thanks.
Look at the Index properties dialog box, and select the Options tab. From
there you should be able to specify everything that you need for the index.
If you want to change all existing indexes at once, click on Database ->
Default Physical Op...Index
How can I know when I have to recreate the index of the table or execute the
Check with Mercury Interactive.
Jim Egan [TeamSybase]
Sybase Professional Services
Get your free subscription to PowerTimes at http://www.powertimes.com
I rarely recreate indexes. The exception is clustered indexes which I may occasionally
rebuild. In both cases I would rebuild to get the organization of the index or data more
clustered (get the values/rows closer togeth...Index
As I make an index?
Please explain what you are trying to do.
In the database painter you can select a table and then use the 'create
index' icon to create unique / duplicate indexes.
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.
Eduardo Garc�a Jim�nez (TINSA) wrote in message
>As I make an index?
I want to make an index as in the books
Terry Dykstra [TeamPS] escribi=F3:
> Please explain what you are trying to do.
> In the database painter you can select a table and then use ...