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...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...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...ASA To ASE - VS
What are the differents in terms of configuring SQL Remote Between ASA to
ASE and ASE To ASE ?
You should start with the Help file and then ask specific questions:
Data Replication with SQL Remote
PART 5. Appendix
APPENDIX A. Enterprise and Anywhere: Differences
There are many differences, so begin there.
Please only post to the newsgroup
BH Ong <email@example.com> wrote in message
> What are the differents in terms of configuring SQL Remote Between ASA to
> ASE and ASE To ASE ...ASE function indexes
Will ASE support function based indexes in the future? I hate having to
create other columns on reporting tables to truncate time so that I can get
a good cluster on date. This is true for potentially other datatypes as
well. Creating other columns and tables and triggers is not the answer. It
adds complexity to the system and a increased risk of exposure to problems.
So, does Sybase have any plans here?
...Clustered Indexes in ASE
1. We have a table that is effectively a queue, all the IO is on the last
100 or so records added to the table.
Sustained rates of insert at 50 msgs a second occur.
From reading on sybase I have seen some conflicting points of view
On one hand it is suggested that columns of low cardinality should be chosen
for clustered indexes, but at the same time there must be a benifit in
having a clustered index that is firstly unique and secondly non sequential
(to avoid landing all insert IO on several pages of table)
What is a reasonable guide to choosing an index for a table like ...Adding ASE to existing ASE-to-ASE Installation
I am using all ASE's in my SQLRemote setup.
My current installation consists of a Consolidated ASE & 2 Remote ASE's.
My attempt to add another Remote ASE to the existing installation
consists of these steps:
- Install the sqlremote system objects in the new Remote
- Install the stable queues in the new Remote
- Manually extract a bcp file of the shared table from the Cons
- Configure the Cons server for another subscriber
- Configure the new Remote's shared table, publications, &
- Manually b...ASE ; No DESC index elements?
I'm evaluating ASE as an upgrade from SQLA. It appears as if ASC/DESC are
not supported in the creation of indexes?
How do people get around that limitation?
During joins, unlike SQLA, does ASE have the ability to use indexes from
multiple tables when the order by spans multiple tables?
Does ASE have Row Level Triggers?
Any problems with cascade updates and deletes?
Apparently ASE is less flexible from a case sensitivity standpoint? What do
I have to watch out for in this area?
Jack Toering wrote:
> I'm evaluating ASE as an up...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...Dump/Load (from ASE 12.5.4 to ASE 15.x) - VS.
We are in the process of planning the upgrade of our ASE
12.5.4 dataservers to ASE 15.x. What is the most
recommended way to upgrade ASE dataservers from ASE 12.5.4
to ASE 15.x?
1) Install new instances of ASE 15.x and load database
dumps from our ASE 12.5.4 dataservers to the newly installed
ASE 15.x dataservers.
- OR -
2) Use the ASE upgrade utility (sqlupgrade) to upgrade our
existing ASE 12.5.4 dataservers to ASE 15.x.
What are the Pros vs. Cons for loading a 12.5.4 database
into a 15.x ASE dataserver versus performing an ASE
dataserv...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...Index size (ASE 11.5)
we are using ASE 11.5 and our indexes are taking too much space on the
disk. For example in one database data occupy 100MB and indexes 160MB. Even
if we drop all the indexes their space remains allocated and we are not able
to shrink it. Is there any way how to do it?
Roman Sladek wrote:
> we are using ASE 11.5 and our indexes are taking too much space on the
> disk. For example in one database data occupy 100MB and indexes 160MB. Even
> if we drop all the indexes their space remains allocated and we are not a...ASE 12.0 upgrade and Indexes
We will be upgrading our databases from ASE 11.5.1 to 12.0. We will
performing inplace upgrade. I see a singificant optimizer changes.
(ie. no more distribution pages, two new tables to hold statistics etc)
My question is this: Is it necessary to recreate indexes after the upgrade
to ASE 12.0. Has anyone performed ASE 12.0 updrade from 11.5.1 without
My another question is do we need to recreate database objects?
No, you don't need to recreate indexes. However, you do need
run update statistics on all user tables. Once done the statistic...