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...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...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...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...Would ASE implement BitMap index or BitWise index?
Dose ASE has any plan to implement BitMap index?
Any what's the advantage of BitWise index. I just know it's a patent
technology of SYBASE while BitMap index is a all-known technology based on
Thanks a lot.
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii; format=flowed
> Dose ASE has any plan to implement BitMap index?
> Any what's the advantage of ...windows ME questions, questions, questions.......
my next PC will be running Windows ME. The PC will be supplied via my work,
so there's no choice here for me (ME?) (I think I would have preferred 98
SE). The harddisk (40GB matrox) will have ME installed, and both the Windows
ME set-up files and an image of the initial Harddisk 'on a hidden
partition'. Word has it that this partition is not seen by Format nor FDisk.
Is this really possible?
No Windows CD will be supplied. Seems a new way of MS to encourage working
with licensed software only.
Anyone familiar with this way of distributing an OS?
Will I be able to ...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...Question about questions
Name: Edward Newill
Summary: Question about questions
Is there an email address that I can send a question too? I could not
find one in the Service area of your site.
I would like to know how I create signatures for my Thunderbird email?
Browser Details: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
From URL: http://hendrix.mozilla.org/
...ASE and ASE
Could it be possible to take scripts from ASA and load them in an ASE
Any information is welcome
ASA supports a fairly large sub-set of Transact-SQL, so if you write your
stored procedures and triggers in ASA using T-SQL, you should be able to
create scripts that will run against both ASE and ASA. If you're planning
to do this though, I would suggest developing your database schema against
ASA, since everything you write in T-SQL in ASA will be supported on ASE,
but the reverse is not true.
Check out the section in the ASA documentation entitled "Tra...Index question
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 ...ASE to ASE
Is anyone out there doing ASE to ASE replication using SQL remote? If
you are have created your own version of the SSEXTRACT utility to set up
a replicant database in ASE rather than ASA? Or does anyone know if
SYBASE has created a version SSEXTRACT for use with ASE to ASE
Thanks in advance
I thought the SQL Remote Replication support in ASE11.5 was meant for a
consolidate-database only (by design)! At least that was what Sybase
said when they announced support for SQL Remote technology support in
I will be happy to...Administrative question
Not quite a client question but I couldn't find a group for
administration. Running ConsoleOne with GroupWise snapins.
I'm unable to find how to access the Admin defined fields.
There apparently has been some leftover information that we
want to expunge.
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.novell....A Question about ASE
My DBServer name is called 'bank', there are many files name like bank.001,
bank.002,......and so on auto-generated by ASE in path $sybase/ASE-12_5/ .I
want make the files generate into any other path that I appointed, how can i
US Marine Corps wrote:
> My DBServer name is called 'bank', there are many files name like bank.001,
> bank.002,......and so on auto-generated by ASE in path $sybase/ASE-12_5/ .I
> want make the files generate into any other path that I appointed, how can i
These files are historical configuration files...indexing question
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...