Toad World® Forums

Sybase ASE table without index


#1

Hi,

When I try a select on a sybase table that has no index i get the following error message:
Sybase Database Error: The optimizer could not find a unique index which it could use to perform an isolation level 0 scan on table

Is there an option in tda to not look for an index when you do a select?

Thanks

TDA vesrion: 2.1.0.227


#2

The is an issue caused by not setting the isolation level correctly by TDA. To resolve this issue please upgrade to the latest version of TDA (2.6.2)

Debbie

P.S. It was fixed in version 2.5.