Re: Two interesting features of Sybase that Informix may want

Mike Segel wrote: > > to consider... > > Sybase allows the programmer to *suggest* an index in a query. > This is handy because of some quirky behavior in their optimizer. > > Whats nice, is that you can ask for a specific index to be used > so that you don't have to do a table scan due to *other* issues. > > The other nice issue is that you can specify a "noholdlock" keyword > within the query. This would set the query to act at an isolation level > of 0, > which in informix lingo, allows for dirty reads. It really comes in > handy. > > The only drawback is that if you are using Rogue Wave C++, you may have > some > bizarre side effects unless you are writing dynamic SQL. > > -Mikey SET TRANSACTION is similar to noholdlock but not specific to a single SELECT - it applies to an entire transaction. However, it is ANSI standard. Does Sybase offer it? -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 --- If all else fails, read the instructions AND the release notes. All opinions are my own and not those of Bayer plc. My Internet plumbing does not allow me to mail and post news together. Sorry. --- Join Infuse, the UK Informix User Group at http://www.infuse.org.uk/