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...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...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...How make a query in terms of File Index value in Index Server ?
I'm writing a Search Query in Index Server SQL language. but not able to get the index value of any document in the Index Server. As this code
strQuery = "Select Filename,PATH from Scope() where FREETEXT('" +strsearchstrings+ "')"; string connstring = "Provider=MSIDXS.1;Integrated Security .='';Data Source="+strCatalog;
as shown in the example above i want make a query in in terms of Index of the doc file stored in the Index Server.Is it possible? I tried but its not working out I dont know where the probl...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...QF Index File was not found-need to regenerate index (Err C080)
QF Index File was not found-need to regenerate index (Err C080)
If I have one server with a POA loaded to do indexing for a postoffice on
a different server, can I do a Ctrl Shift Q on the indexing server to
regenerate indexes and get rid of the above error I am seeing on the
indexing POA screen? All agents are version 6.5.3
Or would I use F10/Actions/Quickfinder/Delete and Regenerate all Indexes
to do this?
Seems like somewhere I read that Ctrl Shift Q on GW 6.x does not work
Thanks in advance!
It should work fine
Dave Parkes [NSCS...index file
I would like to know how many times the adaptive server index
Does the "full text search engine" search on internet?
EAServer doesnt include a full text engine.
Internet Applications Division
<joe> wrote in message
> I would like to know how many times the adaptive server index
> the file?
> Does the "full text search engine" search on internet?
Take a look at Fulcrum or Verity.
What would happen if someone deletes the IDX files from OFUERSINDEX?
Things get broken. These are all the quick finder indexes and without
those, performance is very poor and there will be a bunch of errors.
To recreate them, try this TID
On Mon, 30 Apr 2007 21:10:06 GMT, email@example.com (dtom) wrote:
>What would happen if someone deletes the IDX files from OFUERSINDEX?
Tim Heywood (...Index file
I have Apache running on one of my 6 servers. I have added pictures many
times to our internal site and create tables to show them. How can I just
show them as an index file would? I really don't want to have to create
I hope this makes sense.
It appears that in the past few days you have not received a response to your posting. That concerns us, and has triggered this automated reply.
Has your problem been resolved? If not, you might try one of the following options:
- Do a search of our knowledgebase at http://support.no...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...Netware 6.5 WebSearch indexing files on a remote server
Content-Type: text/plain; charset=iso-8859-1
What is the best/easiest way to enable searching an index on one Netware =
Server for files on a second Netware server? I have seen people talking =
about using NFS Gateway, and also creating and index on the second machine =
then copying the index to the first server. Does anything need to be done =
on the first server to be able to search this index?
Thanks for any suggestions.
Content-Type: multipart/related; bounda...File index
I don't know if this is in the correct forum thread, but here goes...
I am looking for .net code that will index files in a folder at a scheduled time and display the names of the file in an interface. What I am more specifically needing is when someone FTP video, image, or text files that the "program" kicks off and scans the file names in the folder. The file names are then listed in an XML file. After that, we can take it from there as far as preparing that stuff for our purposes. I've seen it done before, so can anyone offer...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" <firstname.lastname@example.org> 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 ?
>...Can cassini webserver configured to detect index.htm,index.html,home.html etc pages as startup page