How can I check if .db file is fragmented and how can I
defragment it to optimize performance.

Deepali,

Deepali wrote:
The database console window will say something along the lines of:

"Performance warning: Database file "<database.db>" consists of <#> disk
fragments"

You can then run Disk Defragmenter, Contig (
http://technet.microsoft.com/en-us/s.../bb897428.aspx ), or
another third-party disk defragmenting utility to solve this.

*Note: This is usually a very small performance issue in most cases.

---

Breck has some good information here about defragmentation as well:

http://sqlanywhere.blogspot.com/2008...rary-file.html

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/libr...ere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summ...&timeframe =0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/