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...indexes on bit fields
Why can't indexes be created on bit fields?
<mike> wrote in message
> Why can't indexes be created on bit fields?
This has been the case for as long as Sybase exists. I don't know why
this is though -- I came across this limitation myself a few years
ago, when trying to add some indexes to speed up certain queries.
Since then I've asked various Sybase engineers, and they all seemed
surprised that such a limitation existed, and nobody had an idea why.
They mumbled things like 'w...bit wise operation
s it possible to do a bit wise operation in SQLA?
...When should we rebuild indexes on IQ
Sybase IQ manuals and Sybase Support indicates that we don't
require to rebuild IQ indexes.Many customers do.
People that rebuild indexes on IQ can you please provide the
criteria that you follow to decide when an index is
fragmented it and need to be rebuild
Are you using at all the sp_iqindexfragmentation
...Bit index type
This is a multi-part message in MIME format.
Content-Type: text/plain; charset="ISO-8859-1"
When I click in physical data model "check model"
I get powerdesigner error
The following error occured while executing a script of
"Bit Index Type".
RuntimeError Micosoft VB script
Variable not defined: "UCaseDttp" (0x800A01F4)
At line 144, character 7.
physical data model (SQL Anywhere 12)
power designer 18.104.22.16848
I found one response about it
Function UCaseD...David Brooks Wises Up (A Bit)
the crisis in US conservatism is fascinating.
Markets tend toward efficiency. People respond in pretty straightforward
ways to incentives. The invisible hand forms a spontaneous, dynamic
order. Economic behavior can be accurately predicted through elegant models.
This view explains a lot, but not the current financial crisis — how so
many people could be so stupid, incompetent and self-destructive all at
once. The crisis has delivered a blow to classical economic...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...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...64 bit ODBC driver for IQ?
do anyone know if there is a 64 bit ODBC driver for IQ?
Thanks in advance,
...Bit-wise arithmetic operations with PB
Does PB support bit-wise (or byte-wise) operations like XOR, AND, OR
/* Pilot Bilgisayar Yaz�l�m Hizmetleri Ltd. �ti.
B�kl�m Sok. 20/20 K.Dere 06660 Ankara
Tel: 0312 4197163 Faks: 0312 4197164
Not directly, but they can be scripted. In fact, they've been scripted
in the PFC Numeric service, so you might want to start there.
Terry [TeamPS] and Sequel the techno-kitten
On Thu, 14 May 1998 10:31:17 +...IQ Crashing when Join Indexes Implemented
We are currently evaluating Sybase Adaptive Server IQ 12.4.0 on NT 4.0
After submitting a semi complex query (see below), the IQ server crashes
with the following error:
exception: access access violation (0xc0000005),
Then, the "Interactive SQL" utility generates this message:
error at line 1
The NT Event Viewer shows only one message:
"performance counters opened."
We would appreciate any feedback from those who have experienced this
error an...PB missing bit-wise or(||) and and(&&)?
I have set up several "constant long ic_bitpos_1 = 1, _2 = 2, _3 = 4",
etc... and need to use
them in a comparison against another long int with a cumulative value:
Here's the old VB code:
Select Case at_Right_Type
Security_Right = ((ao_Group_Rights.Rights_Codes And
at_Right_Mask) <> 0)
and the new PB code:
choose case ii_bit_position
lb_result = (il_group_value or ic_bitpos_1 <> 0)
lb_result = (il_group_value or ic_bitpos_2 <> 0)
lb_result = false // be safe...A bit about WinInet's Index.dat
Found this while searching around for info on index.dat. Found the
link in the external links section of the Wikipedia article on index.dat
Friday, August 04, 2006 3:55 PM by wndpteam
A bit about WinInet's Index.dat
Since a recent digg article and its underlying Wikipedia entry seems a
little confused about index.dat, I�d like to give some more detail
about what it is and what we have changed with it in IE7/Vista�s
version of WinInet. As Jeffdav explained a while back, the index.dat